Excel Formula For Week Ending/Bi Weekly
Published February 19, 2013 at 7:41 pm - No Comments
Quick excel formula I wanted to share with you guys: Lets say your date values were in column C2. To find the correct week ending/starting date, use the following formula in A2: Week Ending (Monday) =C2+7-WEEKDAY(C2) (NEED TO FIX) Week Starting (Monday) =C3-WEEKDAY(C3,3) You may need to add an additional value after the C2 depending [...]
Find Statistical Significance in Excel for A/B Ad Copy or Landing Page Tests
Published January 28, 2013 at 10:00 pm - No Comments
Below returns the P-Value. Since tests are two tailed, a .95 is equivalent to .05 (it just depends on which order you enter the data). To use this formula, visit How to Install VBA Macros in Excel. After you have installed it, go back to your worksheet and type =SignificantTest(A1,A2,B1,B2) where: A1 = Impressions for [...]
Latest Articles
Latest Articles from the Blog
- Excel Formula For Week Ending/Bi WeeklyPublished February 19, 2013 at 7:41 pm
- Find Statistical Significance in Excel for A/B Ad Copy or Landing Page TestsPublished January 28, 2013 at 10:00 pm
- Excel Formula Generator For Delineated TextPublished August 21, 2012 at 9:40 pm
- Automate PowerPoint From ExcelPublished July 11, 2012 at 4:01 pm
- Coming Soon: Excel VBA Framework for PowerPoint!Published June 14, 2012 at 7:09 pm
- VBA: Mediaplex Export Sheet to Columns FormatPublished May 4, 2012 at 9:50 pm
- Convert AdWords Keywords w/ Quotes and Brackets to Keywords with Match TypePublished March 29, 2012 at 5:58 pm
- Wishlist for Google AdwordsPublished March 22, 2012 at 8:19 pm
COPYRIGHT BY Jon Lorenzini's E-Portfolio | LAYOUT BY IWEBIX Webdesign
Me.