# Data Analysis Assignment

2401 words 10 pages
Amanda Mueller
MBA6018 – Data Analysis
Unit 3 Activity 1
January 23, 2013

Practical Application Scenario 1

In 2010, Playbill Magazine contracted Boos Allen to conduct a survey aimed at determining the average annual household income of Playbill readers. 300 readers were randomly pulled and sampled from the list of customers provided by Playbill Magazine. From that sampling effort, Boos Allen was confident that the population average household income is \$119,155 and that the population sample household income standard deviation is \$30,000.

Two Playbill executives recently hypothesized that the average annual household income of its readership has increased and so believe that the magazine price should also increase. From a

Both of these values are larger than the hypothesized population mean of \$119,155. Therefore, it can be concluded that Playbill Magazine can increase the selling price of its magazine. Input Variables: | | Sample Mean (x-bar) | 124450 | Population Standard Deviation (sigma): | 30000 | Sample Size (n): | 300 | Confidence Level: | 0.95 | | | Intermediate Calculations: | | Standard Error of the Estimate: | 1732.05081 | Prob. in One Tail for This Conf Level: | 0.025 | Prob. To Use in NORMSINV: | 0.975 | Z-Multiple: | 1.960 | | | Confidence Interval: | | Lower Limit: | 121055.24 | Upper Limit: | 127844.76 | Margin of Error: | 3394.76 |

Even if the α value was lowered to 0.01, the null hypothesis would still be rejected because the p-value of 0.00114 is less than the α value of 0.01. Using a confidence interval test, one can determine that, even with the smaller α value of 0.01, both the lower limit (\$119,988) and the upper limit (\$128,911) are still larger than the hypothesized population mean of \$119,155. With an α value of 0.01, one can be 99% confident that the population mean (annual household income of Playbill readers) is between \$119,988 and \$128,911. In this case, the null hypothesis H0 would again be rejected, and the price of the magazine would increase. Input Variables: | | Sample Mean (x-bar) | 124450 |

## Related

• ###### Regression Analysis and Summary Page Results
2450 words | 10 pages
• ###### DMD Case Analysis
3586 words | 15 pages
• ###### Atm Assignment
3029 words | 13 pages
• ###### Sec 435 Week 3 Assignment 1 Business Security Posture Sec435 Week 3 Assignment 1 Business Security Posture
3028 words | 13 pages
• ###### Information Decision Making
1341 words | 6 pages
• ###### Strategic Management and Individual Assignment
2565 words | 11 pages
• ###### Atl Assignment
2094 words | 9 pages
• ###### Dissertation on Employee Retention Techniques
18845 words | 76 pages
• ###### Fina6204
1541 words | 7 pages
• ###### Strayer Pad 520 Entire Course
4283 words | 18 pages