Assume you ran a multiple regression to gain a better understanding of the relationship between lumber sales, housing starts, and commercial construction. The regression uses LumberSales (in $100,000s) as the response variable with HousingStarts (in 1,000s) and Commercial Construction (in 1,000s) as the explanatory variables. The results of the regression are as follows:
df | SS | MS | F | SignificanceF | |
Regression | 2 | 180,770 | 90,385 | 103 | 0 |
Residual | 45 | 39,375 | 875 | ||
Total | 47 | 220,145 |
Coefficients | Standard Error |
t-stat | p-value | |
Intercept | 5,37 | 1,71 | 3,14 | 0,0030 |
Housing Starts | 0,76 | 0,09 | 8,44 | 0,0000 |
Commercial Construction |
1,25 | 0,33 | 3,78 | 0,0005 |
Requirement:
a. At the 5% significance level, are the explanatory variables jointly significant in explaining LumberSales? Explain.
b. At the 5% significance level, is Commercial Construction significant in explaining LumberSales? Explain.
c. At the 5% significance level, can you conclude that the slope coefficient attached to HousingStarts differs from 1? Explain.
(please if can, show me in excel/spreadsheet)
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- The following multiple linear regression depicts the sales of Unilever Corporation: S = 10- 0.20P + 0.06TA + 0.08RA Where:S: Sales (Unit);P: Price ($/Unit);TA: Television advertising ($)RA: Radio advertising ($). 1. Interpret the slopes;2. Is television advertising more effective than radio advertising? Why or why not?3. What is the effect of a $1 increase in price, a $3 increase in TV advertising, and a $2decrease in radio advertising on sales?4. What is the effect of a $2 decrease in price, a $2 decrease in TV advertising, and a $4increase in radio advertising on sales?arrow_forwardMultiple Cholce 0.1352 0.1563 0.8446 0.8648arrow_forwardBecause colas tend to replace healthier beverages and colas contain caffeine and phosphoric acid, researchers wanted to know whether cola consumption is associated with lower bone mineral density in women. The accompanying data lists the typical number of cans of cola consumed in a week and the femoral neck bone mineral density for a sample of 15 women. Complete parts (a) through (d) below. Click the icon to view the women's data. (a) Find the regression equation treating cola consumption per week as the x-variable. y=x+ (Round to three decimal places as needed.) (b) Interpret the slope. Select the correct choice below and, if necessary, fill in the answer box to complete your choice. OA. For 0 colas consumed in a week, the bone density is predicted to be (Round to three decimal places as needed.) g/cm³. OB. For every cola consumed per week, the bone density decreases by (Round to three decimal places as needed.) g/cm³, on average. OC. For a bone density of 0 g/cm³, the number of colas…arrow_forward
- The manager of a car dealership wants to predict the relationship between number of sales persons and the number of cars sold. He collects some data to develop a regression model, which is given below Week Number of cars sold Number of salespersons 1 80 6 2 90 8 3 48 4 4 55 5 5 60 7 6 75 9 7 100 11 8 70 6 9 65 7 10 98 10 (i) Run a regression analysis which explains the number of cars sold in terms of number of salespersons, and estimate the regression line (ii) Interpret the regression coefficient, and determine the significance of the regression coefficient (iii) Interpret the overall model fit…arrow_forwardFor the data below, what is the value of "b" for the regression equation? Family Father Son 120 121 110 105 120 125 92 87 85 92 72 90 107 110 115 122 155 133 90 123arrow_forwardA real estate analyst believes that the three main factors that influence an apartment's rent in a college town are the number of bedrooms, the number of bathrooms, and the apartment's square footage. For 40 apartments, she collects data on the rent (y, in $), the number of bedrooms (x1), the number of bathrooms (x2), and its square footage (X3). The following table shows a portion of the regression results. ANOVA Significance df SS MS F F gression Residual 3 5694717 1898239 50.88 4.99E-13 36 1343176 37310 Total 39 7037893 Standard Upper 95% Coefficients Error t Stat p-value_Lower 95% Intercept 300 84.0 3.57 0.0010 130.03 470.79 Bed 226 60.3 3.75 0.0006 103.45 348.17 Bath 89 55.9 1.59 0.1195 -24.24 202.77 Sqft 0.2 0.09 2.22 0.0276 0.024 0.39 What would be the rent for a 1000-square-foot apartment that has 2 bedrooms and 2 bathrooms? $840 $1,335 $1,130 $1,260arrow_forward
- The data show the number of viewers for television stars with certain salaries. Find the regression equation, letting salary be the independent (x) variable. Find the best predicted number of viewers for a television star with a salary of $13 million. Is the result close to the actual number of viewers, 5.7 million? Use a significance level of 0.05. 98 Salary (millions of $) Viewers (millions) 14 2 3.2 9.1 4.6 11 11 7 14 1 D 10.8 10.7 6.3 2.9 4.4 Click the icon to view the critical values of the Pearson correlation coefficient r. Critical Values of the Pearson Correlation Coefficient r What is the regression equation? Critical Values of the Pearson Correlation Coefficient r n α = 0.05 α = 0.01 NOTE: To test H₂: p=0 = + x (Round to three decimal places as needed.) 4 0.950 0.990 against H₁: p‡0, reject Ho 5 0.878 0.959 if the absolute value of r is 6 0.811 0.917 greater than the critical What is the best predicted number of viewers for a television star with a salary of $13 million? The…arrow_forwardonsider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume(units) Total Cost($) 400 3,900 450 4,900 550 5,500 600 5,900 700 6,400 750 7,100 This data was used to develop an estimated regression equation, ŷ = 970.67 + 8.08x, relating production volume and cost for a particular manufacturing operation. Use ? = 0.05 to test whether the production volume is significantly related to the total cost. (Use the F test.) Set up the ANOVA table. (Round your p-value to three decimal places and all other values to two decimal places.) Sourceof Variation Sumof Squares Degreesof Freedom MeanSquare F p-value Regression Error Total Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value = What is your conclusion? Reject H0. We conclude that the relationship between production…arrow_forwardUse the time/tip data from the table below, which includes data from New York City taxi rides. (The distances are in miles, the times are in minutes, the fares are in dollars, and the tips are in dollars.) Find the regression equation, letting time be the predictor (x) variable. Find the best predicted tip for a ride that takes 30 minutes. How does the result compare to the actual tip amount of $4.70? Use a significance level of 0.05. Distance 1.80 12.71 1.32 Time 1.65 8.51 1.40 1.02 2.47 Fare Tip 25.00 27.00 8.00 16.30 36.80 7.80 9.80 31.75 12.30 1.50 0.00 0.00 1.96 2.98 2.46 11.00 31.00 18.00 8.00 18.00 7.80 14.30 2.34 4.29 The regression equation is ŷ =+ (x. (Round the y-intercept to two decimal places as needed. Round the slope to four decimal places as needed.)arrow_forward
- Corvette, Ferrari, and Jaguar produced a variety of classic cars that continue to increase in value. The data showing the rarity rating (1–20) and the high price ($1000s) for 15 classic cars is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet Develop a scatter diagram of the data using the rarity rating as the independent variable and price as the dependent variable. Does a simple linear regression model appear to be appropriate? A simple linear regression model _________appearsdoes not appear to be appropriate. Develop an estimated multiple regression equation with rarity rating and as the two independent variables. (to whole numbers) What is the value of the coefficient of determination? Note: report between 0 and 1. (to 3 decimals) What is the value of the test statistic? (to 2 decimals) What is the -value? (to 4 decimals) Consider the nonlinear relationship shown by equation .…arrow_forwardThe personnel director of a large hospital is interested in determining the relationship (if any) between an employee’s age and the number of sick days the employee takes per year. The director randomly selects ten employees and records their age and the number of sick days which they took in the previous year. Employee 1 2 3 4 5 6 7 8 9 10 Age 30 50 40 55 30 28 60 25 30 45 Sick Days 7 4 3 2 9 10 0 8 5 2 Copy Data The estimated regression line and the standard error are given. Sick Days=14.310162−0.2369(Age) se=1.682207se=1.682207 Find the 95% confidence interval for the average number of sick days an employee will take per year, given the employee is 26. Round your answer to two decimal places.arrow_forwardThe data show the chest size and weight of several bears. Find the regression equation, letting chest size be the independent (x) variable. Then find the best predicted weight of a bear with a chest size of 58 inches. Is the result close to the actual weight of 572 pounds? Use a significance level of 0.05. Chest size (inches) 46 57 53 41 40 40 Weight (pounds) 384 580 542 358 306 320 LOADING... Click the icon to view the critical values of the Pearson correlation coefficient r. What is the regression equation? y=nothing+nothingx (Round to one decimal place as needed.)arrow_forward
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman