Question

In: Statistics and Probability

A government researcher is analyzing the relationship between retail sales (in $ millions) and the gross...

A government researcher is analyzing the relationship between retail sales (in $ millions) and the gross national product (GNP in $ billions). He also wonders whether there are significant differences in retail sales related to the quarters of the year. He collects 10 years of quarterly data. A portion is shown in the accompanying table. Retail sales (in millions) GNP (in billions) d1 d2 d3 2000 1 696048 9740.5 1 0 0 2 753211 9983.5 0 1 0 3 746875 10048.0 0 0 1 4 792622 10184.9 0 0 0 2001 1 704757 10206.2 1 0 0 2 779011 10350.9 0 1 0 3 756128 10332.2 0 0 1 4 827829 10463.1 0 0 0 2002 1 717302 10549.7 1 0 0 2 790486 10634.7 0 1 0 3 792657 10749.1 0 0 1 4 833877 10832.2 0 0 0 2003 1 741233 10940.2 1 0 0 2 819940 11073.6 0 1 0 3 831222 11321.2 0 0 1 4 875437 11508.3 0 0 0 2004 1 795916 11707.8 1 0 0 2 871970 11864.2 0 1 0 3 873695 12047.3 0 0 1 4 938213 12216.6 0 0 0 2005 1 836952 12486.3 1 0 0 2 932713 12613.0 0 1 0 3 940880 12848.7 0 0 1 4 987085 12994.1 0 0 0 2006 1 897180 13264.0 1 0 0 2 987406 13423.3 0 1 0 3 978211 13514.8 0 0 1 4 1018775 13683.2 0 0 0 2007 1 923997 13859.8 1 0 0 2 1016136 14087.6 0 1 0 3 1002312 14302.9 0 0 1 4 1062803 14489.9 0 0 0 2008 1 953358 14520.7 1 0 0 2 1032919 14647.3 0 1 0 3 1006551 14689.2 0 0 1 4 966329 14317.2 0 0 0 2009 1 839625 14172.2 1 0 0 2 919646 14164.2 0 1 0 3 926265 14281.9 0 0 1 4 985649 14442.8 0 0 0

a. Estimate y = β0 + β1x + β2d1 + β3d2 + β4d3 where y is retail sales, x is GNP, d1 is a dummy variable that equals 1 if quarter 1 and 0 otherwise, d2 is a dummy variable that equals 1 if quarter 2 and 0 otherwise, and d3 is a dummy variable that equals 1 if quarter 3 and 0 otherwise. Here the reference category is quarter 4. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)

d-1. Reformulate the model to determine, at the 5% significance level, if sales differ between quarter 2 and quarter 3. Your model must account for all quarters. Use quarter 3 as the reference category. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.)

Solutions

Expert Solution

`


Related Solutions

The movie industry is a competitive business. The opening weekend gross sales ($ millions), the total...
The movie industry is a competitive business. The opening weekend gross sales ($ millions), the total gross sales ($ millions), the number of theaters the movie was shown in, and the number of weeks the movie was in release are common variables used to measure the success of a movie. Data on the top 100 grossing movies released in 2016 (Box Office Mojo website) are contained in the attached Excel file. We will use the numerical methods of descriptive statistics...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​ dollars) for randomly selected movies. Answer parts ​a-c. Budget (x)   Gross (y) 63   60 93   66 45   51 31   57 203   624 105   143 90   46 a. Find the value of the linear correlation coefficient b. Find the critical values of r from the table showing the critical values for the Pearson correlation coefficient using α=0.05. c. Is there sufficient evidence to conclude that...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​...
Listed below are the budgets​ (in millions of​ dollars) and the gross receipts​ (in millions of​ dollars) for randomly selected movies. Construct a​ scatterplot, find the value of the linear correlation coefficient​ r, and find the​ P-value using alphaequals0.05. Is there sufficient evidence to conclude that there is a linear correlation between budgets and gross​ receipts? Do the results change if the actual budgets listed are ​$60,000,000​, ​$91,000,000​, ​$48,000,000​, and so​ on? Budget​ (x) 60 91 48 40 196 100...
A researcher is interested to learn if there is a relationship between the level of interaction...
A researcher is interested to learn if there is a relationship between the level of interaction a women in her 20s has with her mother and her life satisfaction ranking. Below is a list of women who fit into each of four level of interaction. Conduct a One-Way ANOVA on the data to determine if a relationship exists. State whether or not a relationship exists and why or why not. Explain in as much detail as possible. No Interaction Low...
A researcher is interested to learn if there is a linear relationship between the hours in...
A researcher is interested to learn if there is a linear relationship between the hours in a week spent exercising and a persons life satisfaction. The researchers collected the following data from a random sample, which included the number of hours spent exercising in a week and a ranking of life satisfaction from 1 to 10 ( 1 being the lowest and 10 the highest). Participant Hours of Exercise Life Satisfaction 1 3 1 2 14 2 3 14 4...
A sports researcher is interested in determining if there is a relationship between the number of...
A sports researcher is interested in determining if there is a relationship between the number of home wins depends on the sport. A random sample of 200 games is selected and the results are given below. Football Basketball Soccer Baseball Home team wins 30 20 15 35 Visiting team wins 20 30 35 15 What is the test statistic value for the above data? A 4 B 10 C 20 D None of the above
A sports researcher is interested in determining if there is a relationship between the number of...
A sports researcher is interested in determining if there is a relationship between the number of home team and visiting team wins and different sports. A random sample of 633 games is selected and the results are given below. Conduct test of hypothesis to test the claim that the number of home team and visiting team wins is independent of the sport. Use a=0.05. Football BasketBall Soccer Baseball Hometeam Wins 89 165 91 49 Visiting Team Wins 60 89 52...
A researcher asks if there is a relationship between the number of errors on a math...
A researcher asks if there is a relationship between the number of errors on a math test (X) and the person's level of satisfaction with the performance (Y). The data collected from seven participants is as follow: Participant 1 2 3 4 5 6 7 Variable X 9 8 4 6 7 10 5 Variable Y 3 2 8 5 4 2 7 a. Compute the mean and standard deviation for each variable. b. Create a scaterplot to have a...
A researcher is interested to learn if there is a linear relationship between the hours in...
A researcher is interested to learn if there is a linear relationship between the hours in a week spent exercising and a person’s life satisfaction. The researchers collected the following data from a random sample, which included the number of hours spent exercising in a week and a ranking of life satisfaction from 1 to 10 ( 1 being the lowest and 10 the highest). PLEASE help in SPSS. Participant Hours of Exercise Life Satisfaction 1 3 1 2 14...
Question 4 A researcher wants to know the relationship between murder and robbery. The researcher recorded...
Question 4 A researcher wants to know the relationship between murder and robbery. The researcher recorded the number of murders and robberies per 100,000 population for a random selection of cities. Help the researcher to find the relationship between the two variables. Murders, x 2.4 2.7 5.6 2.6 2.1 3.3 6.6 5.7 Robberies, y 25 14 151 91 80 49 173 96         a. Calculate the correlation coefficient, R. Interpret the calculated value of R.       b. Briefly comment on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT