You own a company that sells high-end motorcycles. You are considering launching ...

profileguru2009
 (Not rated)
 (Not rated)
Chat

      You own a company that sells high-end motorcycles. You are   considering launching a new marketing campaign in an attempt to increases   sales but you are unsure of when you should start it. You believe it makes   the most sense to market more when the fewest number of people typically buy   motorcycles. So, you decided to use your quarterly sales data from the past   2+ years to test to see if there is a difference in sales between the   quarters and if so, which quarter had the lowest sales.   For this   question, you will need to download the Sales Data and then use the data   analysis tool pack in Excel to run an Anova: Single Factor Test. Note, you   will need to install the data analysis tool pack on your computer. How to do   this differs based on the type of computer you are using, but instructions   can be found on google for both Mac and PC.   Sales Data:   https://arizona.grtep.com/core/uploadfiles/components/283631/files/Sales%20Data.xlsx   How many   pair-wise comparisons or Fisher’s confidence intervals would you need to   calculate in order to compare all of the quarters versus one another? (i.e.   Quarter 1 versus Quarter 2 is one pair. Quarter 1 versus Quarter 3 is another   pair.)   From the   ANOVA output, enter the following. Round your answers to 4 decimals.   F = Test   Statistic =   F crit =   critical value =   p-value =    df2 =   nT – c =   Mean Square   Error (MSE) =   Calculate a   95% Fisher’s confidence interval between Quarter 1 and Quarter 2. Let Quarter   1 be population 1 and Quarter 2 be population 2 in the formula. Round   your answer to 2 decimals.   Calculate a   95% Fisher’s confidence interval between Quarter 1 and Quarter 3. Let Quarter   1 be population 1 and Quarter 3 be population 2 in the formula. Round   your answer to 2 decimals.    

    • 8 years ago
    (b) We would need C(4, 2) = 6 comparisons ...
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      Youownacompanythatsellshigh-endmotorcycles.Youareconsidering.xlsx
    • attachment
      Youownacompanythatsellshigh-endmotorcycles.Youareconsidering.xlsx