Purchase Solution

Paired t test: No. of ad pages

Not what you're looking for?

Ask Custom Question

I am having problems with Excel. I just don't understand how to make it do what I need it to do.

This is what I have in Excel 2010:
Magazine 2008 2009
Details 72.31 48.42
Esquire 66.69 42.79
Field & Stream 48.65 42.82
Flex 219.61 231.58
GQ 99.21 60.35
Maxim 68.5 41.82
Men's Fitness 99.43 67.63
Men's Health 90.88 74.45
Men's Journal 183.1 88.34
Mucscle & Fitness 169.63 198.93
Outdoor Life 41.39 30.16
Outside 126.97 103.58

In tough economic times, the business staff at magazines are challenged to sell advertising space in their publications. Thus, one indicator of a weak economy is the decline in the number of "ad pages" that magazines have sold. The file contains the number of ad pages found in the May 2008 and May 2009 issues of 12 men's magazines. (Data extracted from W. Levith, "Magazine Monitor," Mediaweek, April 20, 2009, p. 53.)
a) At the 0.05 level of significance, is there evidence that the mean number of ad pages was higher in May 2008 than in May 2009?
b) What assumption is necessary about the population distribution in order to perform this test?
c) Use a graphical method to evaluate the validity of the assumption in (b).
d) Construct and interpret a 95% confidence interval estimate of the difference in the mean number of ad pages in men's magazines between May 2008 and May 2009.

Please see the attachment

Attachments
Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of testing of hypothesis. Formula for the calculation and interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.

Purchase this Solution
Free BrainMass Quizzes
Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Probability Quiz

Some questions on probability

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

View More Free Quizzes
Related BrainMass Solutions

  • Hypotheses Used for Paired T-tests

    563365 Hypotheses Used for Paired T-tests First, explain in your own words (no direct quotes, please) when you might employ a paired t-Test. Secondly, describe in words the hypothesis that is used for a paired t-Test.

  • Paired Students t test.

    in the average of x and y The solution gives the details of paired t test.

  • Paired Sample Procedure

    Answer H0: There is no significant difference in the mean score of maths and science H1: There is significant difference in the mean score of maths and science Test Statistic: t= where and S are the mean and SD difference .

  • T-Test - Applied Statistics for Psychology

    Step 1: Before you write Ho and Ha, determine what type of test needs to be used. Your choices are t-test for independent samples, t-test for a single sample, or paired sample t-test.

  • Paired Student's t test

    and non alcoholic The appropriate test for this data is paired Students t test The test Statistic used is where is the mean of difference between the brain densities of alcoholic and non alcoholic , s is the SD of difference between

  • independent t test versus paireed t test

    the two-sample independent t test to the paired t test.

  • Difference between Independent Samples&Paired Samples T-test

    364250 Difference between Independent Samples and Paired Samples T-Test In a paragraph explain the differences between the Independent Samples and Paired Samples T-Test. When do you use each?

  • Paired t test: Absenteeism of Employees-MCQs

    What test is most appropriate for this problem? A. Z-test of means B. T-test of paired samples C. T-test of independent samples D. Chi-square - goodness of fit E. Chi-square - test of independence F.

  • Which statistical test to use?

    An alternative procedure that makes no assumptions about the distribution of the data is the Wilcoxon Test, but this test is less powerful than the paired sample t-test. Now, I would not use McMemar test. Why?

  • Hypothesis testing for paired sample of officers

    Step 5: Conclusion Since |t|=0.111147NO difference in the mean number of citations given by the two officers The solution uses the five-step hypothesis test to test a

View More Related Solutions