Homework Answers
We will be using the following data:
| Sales | Dealerships | Q1 | Q2 | Q3 |
| 85470 | 4 | 1 | 0 | 0 |
| 101384 | 8 | 1 | 0 | 0 |
| 121303 | 13 | 1 | 0 | 0 |
| 133601 | 16 | 1 | 0 | 0 |
| 194513 | 21 | 1 | 0 | 0 |
| 82157 | 4 | 0 | 1 | 0 |
| 150405 | 8 | 0 | 1 | 0 |
| 242762 | 13 | 0 | 1 | 0 |
| 260353 | 16 | 0 | 1 | 0 |
| 273488 | 21 | 0 | 1 | 0 |
| 65480 | 4 | 0 | 0 | 1 |
| 101458 | 8 | 0 | 0 | 1 |
| 150132 | 13 | 0 | 0 | 1 |
| 165487 | 16 | 0 | 0 | 1 |
| 200406 | 21 | 0 | 0 | 1 |
| 98535 | 4 | 0 | 0 | 0 |
| 200358 | 8 | 0 | 0 | 0 |
| 250155 | 13 | 0 | 0 | 0 |
| 306587 | 16 | 0 | 0 | 0 |
| 389564 | 21 | 0 | 0 | 0 |
In our regression equation, there are three dummy variables (and not four because if all the first three dummy variables have a value of zero, it indicates Quarter 4, hence it is reduntant to include an extra dummy variable in our regression equation)
We can use the above data to make a regression model in Excel or SPSS or in any other statistical software.
In Excel Go to Data -> Data Analysis -> Regression -> Select the data -> OK
In SPSS Go to analyze -> Regression -> Linear
The results are:
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.94504 | |||||||
| R Square | 0.893101 | |||||||
| Adjusted R Square | 0.864595 | |||||||
| Standard Error | 31944.83 | |||||||
| Observations | 20 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 4 | 1.28E+11 | 3.2E+10 | 31.32985 | 4.02E-07 | |||
| Residual | 15 | 1.53E+10 | 1.02E+09 | |||||
| Total | 19 | 1.43E+11 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | 118650.7 | 20626.81 | 5.752257 | 3.82E-05 | 74685.71 | 162615.7 | 74685.71 | 162615.7 |
| Dealerships | 10515.25 | 1199.882 | 8.763565 | 2.75E-07 | 7957.759 | 13072.74 | 7957.759 | 13072.74 |
| Q1 | -121786 | 20203.68 | -6.02789 | 2.31E-05 | -164849 | -78722.5 | -164849 | -78722.5 |
| Q2 | -47206.8 | 20203.68 | -2.33654 | 0.033749 | -90269.9 | -4143.67 | -90269.9 | -4143.67 |
| Q3 | -112447 | 20203.68 | -5.56568 | 5.4E-05 | -155510 | -69384.1 | -155510 | -69384.1 |
We can see that the Q1 coefficient has a value of -121786 with a significant p-value. Hence, the variable Quarter 1 is significant. Hence, as the value is negative, it means that on average, car sales are higher in the 4th quarter than in the 1st quarter at the 0.05 level of significance.
Regression equation is:
Sales = 118650.7 + 10515.25*Dealerships -121786*Quarter 1 - 47206.8*Quarter 2 - 112447*Quarter 3
Add Answer to:
1/11 Question 2 of 10, Step 1 of 1 Correct Suppose the following data were collected...
Question 1 of 9. Step 2 of 2 1/16 Correct The following data was collected to...
Question 1 of 9. Step 2 of 2 1/16 Correct The following data was collected to explore how a students age and GPA affect the number of parking tickets they receive in a given year The dependent variable is the number of parking sekets. the first independent variable in is the students age, and the second Independent variable() is the student's GPA Effects on Number of Parking Tickets GPA Number of Tickets Copy Data Step 2 of 2: Determine if...
Suppose the following data were collected from a sample of 15 CEOs relating annual salary to...
Suppose the following data were collected from a sample of 15
CEOs relating annual salary to years of experience and the economic
sector their company belongs to. Use statistical software to find
the following regression equation:
SALARYi=b0+b1EXPERIENCEi+b2SERVICEi+b3INDUSTRIALi+ei .
Is there enough evidence to support the claim that on average,
CEOs in the industrial sector have lower salaries than CEOs in the
financial sector at the 0.05 level of significance?
If yes, write the regression equation in the spaces provided
with...
Suppose the following data were collected relating the selling price of a house to square footage...
Suppose the following data were collected relating the selling
price of a house to square footage and whether or not the house is
made out of wood. Use statistical software to find the regression
equation. Is there enough evidence to support the claim that on
average wood houses are more expensive than other types of houses
at the 0.01 level of significance? If yes, type the regression
equation in the spaces provided with answers rounded to two decimal
places. Else,...
Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of brick. Use statistical software to find the regression equ...
Suppose the following data were collected relating the selling
price of a house to square footage and whether or not the house is
made out of brick. Use statistical software to find the regression
equation. Is there enough evidence to support the claim that on
average brick houses are more expensive than other types of houses
at the 0.05 level of significance? If yes, type the regression
equation in the spaces provided with answers rounded to two decimal
places. Else,...
The following data was collected to explore how the average number of hours a student studies...
The following data was collected to explore how the average number of hours a student studies per night and the student's PA affect their ACT score. The dependent variable is the ACT score, the first independent variable (ri) is the number of hours spent studying and the second independent variable (x2) is the student's GPA Effects on ACT Scores Study Hours GPA ACT Score 24 21 19 17 Copy Data Step 1 of 2: Find the p-value for the regression...
LAVAN SCALE Question 1 of 16. Step 1 of 1 0/16 Correct A sample of 900...
LAVAN SCALE Question 1 of 16. Step 1 of 1 0/16 Correct A sample of 900 computer chips revealed that 30 % of the chips do not fail in the first 1000 hours of their use. The company's promotional literature claimed that 34 % do not fail in the first 1000 hours of their use. Is there sufficient evidence at the 0.05 level to dispute the company's claim? State the null and alternative hypotheses for the above scenario. Answer E...
Question 4 ·Of 11 Step 2 of 2 01:33:18 The following data was collected to explore...
Question 4 ·Of 11 Step 2 of 2 01:33:18 The following data was collected to explore how the average number of hours a score. The dependent variable is the ACT score, the first independent variable (xi )is the number of hours spent studying,and the second student studies per night and the student's GPA affect their ACT variable (x2) is the student's GPA Effects on ACT Scores Study Hours GPA ACT Score Copy Data Next level of significance. If the relationship...
4/12 Correct Question 5 of 8, Step 1 of1 The table below gives data collected on...
4/12 Correct Question 5 of 8, Step 1 of1 The table below gives data collected on the birth weight of 5 mothers versus the birth weight of their babies. Mother's Birth Weight 5.5 6 8 8.5 9 Baby's Birth Weight 5 5.5 6 6.5 8.5 Calculate the correlation coefficient, r Round your answer to three decimal places Answer How to enter your answer O 2019 Hawkes Learning pe bere to search
Question 3 of 10, Step 1 of 1 0/10 Correct Find the area under the standard...
Question 3 of 10, Step 1 of 1 0/10 Correct Find the area under the standard normal curve to the right ofz =-2.18. Round your answer to four decimal places, if necessary. Answer Tables Keypad If you would like to look up the value in a table, select the table you want to view, then either click the cel at the intersection of the row and column or use the arrow keys to find the appropriate cell in the table...
Question 3 of 12. Step 1 of 1 2/12 Correct Trucks in a delivery fleet travel...
Question 3 of 12. Step 1 of 1 2/12 Correct Trucks in a delivery fleet travel a mean of 90 miles per day with a standard deviation of 21 miles per day. The mileage per day is distributed normally. Find the probability that a truck drives less than 111 miles in a day. Round your answer to four decimal places. Answer B Tables # Keypad Keyboard Shortcuts If you would like to look up the value in a table, select...
Question 1 of 9. Step 2 of 2 1/16 Correct The following data was collected to explore how a students age and GPA affect the number of parking tickets they receive in a given year The dependent variable is the number of parking sekets. the first independent variable in is the students age, and the second Independent variable() is the student's GPA Effects on Number of Parking Tickets GPA Number of Tickets Copy Data Step 2 of 2: Determine if...
Suppose the following data were collected from a sample of 15
CEOs relating annual salary to years of experience and the economic
sector their company belongs to. Use statistical software to find
the following regression equation:
SALARYi=b0+b1EXPERIENCEi+b2SERVICEi+b3INDUSTRIALi+ei .
Is there enough evidence to support the claim that on average,
CEOs in the industrial sector have lower salaries than CEOs in the
financial sector at the 0.05 level of significance?
If yes, write the regression equation in the spaces provided
with...
Suppose the following data were collected relating the selling
price of a house to square footage and whether or not the house is
made out of wood. Use statistical software to find the regression
equation. Is there enough evidence to support the claim that on
average wood houses are more expensive than other types of houses
at the 0.01 level of significance? If yes, type the regression
equation in the spaces provided with answers rounded to two decimal
places. Else,...
Suppose the following data were collected relating the selling
price of a house to square footage and whether or not the house is
made out of brick. Use statistical software to find the regression
equation. Is there enough evidence to support the claim that on
average brick houses are more expensive than other types of houses
at the 0.05 level of significance? If yes, type the regression
equation in the spaces provided with answers rounded to two decimal
places. Else,...
The following data was collected to explore how the average number of hours a student studies per night and the student's PA affect their ACT score. The dependent variable is the ACT score, the first independent variable (ri) is the number of hours spent studying and the second independent variable (x2) is the student's GPA Effects on ACT Scores Study Hours GPA ACT Score 24 21 19 17 Copy Data Step 1 of 2: Find the p-value for the regression...
LAVAN SCALE Question 1 of 16. Step 1 of 1 0/16 Correct A sample of 900 computer chips revealed that 30 % of the chips do not fail in the first 1000 hours of their use. The company's promotional literature claimed that 34 % do not fail in the first 1000 hours of their use. Is there sufficient evidence at the 0.05 level to dispute the company's claim? State the null and alternative hypotheses for the above scenario. Answer E...
Question 4 ·Of 11 Step 2 of 2 01:33:18 The following data was collected to explore how the average number of hours a score. The dependent variable is the ACT score, the first independent variable (xi )is the number of hours spent studying,and the second student studies per night and the student's GPA affect their ACT variable (x2) is the student's GPA Effects on ACT Scores Study Hours GPA ACT Score Copy Data Next level of significance. If the relationship...
4/12 Correct Question 5 of 8, Step 1 of1 The table below gives data collected on the birth weight of 5 mothers versus the birth weight of their babies. Mother's Birth Weight 5.5 6 8 8.5 9 Baby's Birth Weight 5 5.5 6 6.5 8.5 Calculate the correlation coefficient, r Round your answer to three decimal places Answer How to enter your answer O 2019 Hawkes Learning pe bere to search
Question 3 of 10, Step 1 of 1 0/10 Correct Find the area under the standard normal curve to the right ofz =-2.18. Round your answer to four decimal places, if necessary. Answer Tables Keypad If you would like to look up the value in a table, select the table you want to view, then either click the cel at the intersection of the row and column or use the arrow keys to find the appropriate cell in the table...
Question 3 of 12. Step 1 of 1 2/12 Correct Trucks in a delivery fleet travel a mean of 90 miles per day with a standard deviation of 21 miles per day. The mileage per day is distributed normally. Find the probability that a truck drives less than 111 miles in a day. Round your answer to four decimal places. Answer B Tables # Keypad Keyboard Shortcuts If you would like to look up the value in a table, select...
Most questions answered within 3 hours.
-
Calculate the pH of each of the following solutions.
0.50 M HBr
3.1×10−4 M KOH
4.2×10−5...
asked 2 hours ago -
For the year ended December 31, Depot Max’s cost of merchandise
sold was $85,600. Inventory at the...
asked 2 hours ago -
Week 10 - Professional Memo Assignment
Professional Memo Assignment
Your mission for this week, should you...
asked 2 hours ago -
Write a Python program that stores the data for each
player on the team, and it...
asked 2 hours ago -
In
the last 3 months, mike never knows when he is going to get his
allowance...
asked 3 hours ago -
Is Ca(OH)2 a Bronsted base, Lewis base, or both? Why?
asked 2 hours ago -
1A- Why don’t voters complain about U.S. tariffs on imported
sugar?
Because sugar is only a...
asked 3 hours ago -
Cash Payback Period
Primera Banco is evaluating two capital investment proposals for
a drive-up ATM kiosk,...
asked 3 hours ago -
Create a button in Swift (Xcode) that will create a charge,
create a charge using Stripe's...
asked 3 hours ago -
The reaction rate of CO and NO2 in the reaction
CO(g) + NO2(g) → CO2(g) +...
asked 3 hours ago -
Imagine that a chemist puts 6.40 mol each of
C3H8 and O2 in a 1.00-L container...
asked 3 hours ago -
How much money should be invested today in order to have $8340
at the end of...
asked 3 hours ago