Question: How do you fit a multiple linear regression model to predict sales using all independent variables A.) state the population regression model to be estimated.B.)

How do you fit a multiple linear regression model to predict sales using all independent variables A.) state the population regression model to be estimated.B.) describe the goodness of fit of the estimated regression lineC.) state the least squares estimates of the modelD.) give practical meanings (interpret the values) to the parameters of the model E.) test the individual significance of the parameters. Use alpha = 0.05.F.) test the overall significance of the model. Use alpha = 0.05

" IMG_2494 (1).jpg ~ & IMG_2495.jpg ~ Search Q Search Q 6.00 90.00 153.00 0.03 4:00 27.00 Unknown 11778 51 2982.00 0.04 4.00 26.00 Unknown 9722 52 2515.00 13.20 5.00 98.00 141.00 0.04 4.00 Asia 8429 1989.00 11.40 5.00 70.00 90.00 33.00 INDEPENDENT VARIANES DEPENDENT VARIABLE 53 98.00 119.00 0.04 4 00 30.00 Asia 12380 15:00 Displacement HP/Pound Cylinders Max Hwy Origin Price 2482.00 13.70 Weight(b) Cargo Seating Horsepower 92.00 91.00 0.05 4.00 32.00 Asia 10090 5:00 2390.00 16.00 5.00 118.00 97:00 0.05 4.00 30.00 Asia 12670 2039.00 12.20 1.00 D.05 1.00 16.00 Asia 9880 2.00 92.00 3077 00 16.60 500 161.00 163.00 0.05 6.00 22 00 Asia 23400 1819.00 23.20 119.00 0.04 1 00 26 00 Asia 14670 108.00 27 00 19585 5 00 121.00 0.04 Europe 2522.00 11.20 4.00 104.00 2568 00 10 20 Ada 7634 0.03 4.00 31 0 16. 80 5 00 130.00 141 00 0.04 5.00 22.00 Europe 28030 2932.00 2156,00 11.20 5.00 68.00 90.00 33.00 Ada 8609 5:00 168 00 152.00 0.06 6 00 22.00 Europe 26095 0.03 4 00 2835 00 2011.00 11.40 15.00 70.00 90.00 14 30 152.00 0.05 6:00 23.00 Europe 37000 29.40 4.00 110.00 137.00 0.04 4 00 16 00 Asia 14865 3395.00 16 20 500 168.00 17.60 5.00 208.DO 20900 0.05 6.00 19.00 Europe 54000 2727.00 19.00 600 140.0 232.00 0.04 6.00 28.00 Unknown 27468 3835 00 2764 00 15 80 6:00 110.00 151.00 0.04 4 00 30.00 Unknown 13356 3628.00 302.00 0.06 8.00 24.00 Unknown 27218 225.00 6:00 165.00 231.00 0.05 6.00 28.00 185.25 3722.00 14.20 5.00 0.04 Unknown 25205 302.00 8.00 24 00 87.90 8.00 140.0 307.00 0.03 8.00 24.00 19860 4051.00 22.40 6.00 150.00 14459 121.00 159.00 0.03 4.00 24.0 Asia 3267.00 6.00 231 00 0.05 6:00 16730 3463.00 37.50 7.00 165.00 28.00 30.00 Asia 8999 10.30 2:00 165.00 231.00 0.05 6.00 28.00 26700 2175.00 14.70 5.00 82.00 97.00 0.04 4 00 339400 Asia 15 50 600 130.0 173.00 29,00 14739 28.00 13919 6 00 0.04 4.00 3144.00 0.04 2590.00 15.90 5.00 10.00 133.00 6:00 23.0 Asia 21920 13.90 5.00 165.0 231.00 0.05 6.00 28.00 22540 15.10 5.00 158.00 180.0 0.05 51400 13.50 5:00 90.00 121.00 0.04 4:00 32 00 9700 3373.00 3730.00 181.00 6.00 Europe 15.20 5.00 177.00 0.05 19.00 32500 2640.00 13:40 110.00 151.00 0.04 4 00 30.00 12345 159.00 0.05 6.00 23.00 Europe 5.00 158.00 39200 3492.00 16.20 200 200.0 273.00 0.05 23.00 57183 2955.00 11.70 6.00 24.00 Europe 0.03 8.OO 24.00 3210.00 14.60 5,00 188.00 159.00 0.06 4190.00 19.50 6:00 140.0 307.00 4.00 29.00 Unknown 9657 3470.00 18.40 6.00 155.00 273.00 0.04 8.00 25,00 34230 2185.00 28.90 5.00 82.00 97.00 0.04 23.00 25602 6.00 Unknown 29750 3422.00 14.10 5:00 155 00 273.00 0.05 8:00 25.00 3230.00 37.20 5.00 144.00 177.0 0.04 11819 14754 122.00 0.04 4.00 28.00 Asia 3084.00 151 80 155.00 262.00 0.05 6.00 22 00 14635 2601.00 12.30 5.00 102.00 29.00 Asia 9329 3083.00 34.80 4.00 305.00 0.07 8.00 4.00 220.00 25.00 81.00 90.00 0.04 17069 6.00 170.0 305.00 0.05 8.00 24.00 16835 2271.00 10.30 5.00 22.00 Asia 3693.00 2090 12.40 5.00 142.00 181.00 0.05 5.00 Asia 14929 2423.00 13.70 5:00 90.00 121 0 0.04 4.00 32 00 9010 3075.00 4.00 21 0 161.60 7.00 107.00 143.00 0.03 18899 16 20 6:00 98.00 151:00 0.04 4:00 30.00 11495 3285.00 181.00 0.05 6.00 26.00 Asia 13.50 5.00 90.00 121.00 0.03 400 31.00 10475 3086.00 14.50 5.00 160.00 Asia 12269 2595.00 31545 4.00 90.00 97.00 0.04 4.00 29.00 9419 3229.00 17.90 200 245.0 350.00 D.08 8.00 25.00 2388.00 7.00 97.00 0.04 4.00 30.0 Asia 3556.00 15 60 6:00 140.00 318.00 0.04 800 22 00 18345 2231.00 1200 5.00 90.00 0.04 4.00 27.00 Asia 12599 42 60 5.00 93.00 135.00 0.03 28:00 Unknown 12031 2770.00 12.00 5.00 97.0 120.00 4.00 21.0 Asia 1574 0.04 6.00 17416 3214.00 16.50 6.00 141 00 181 00 26.00 Unknown 0.03 3330.00 157.60 7.00 106.00 146.00 0.05 4.00 25.00 Asia 13959 1775.00 33.00 4:00 53.00 61.00 0.03 3.00 42 00 Asia 6397 14.20 400 140.00 146.00 Asia 23049 400 30.00 8371 2690.00 0.05 6.00 26.00 2323.00 15.00 6.00 93.00 135.00 0.04 Unknown 165.00 181.00 14295 150.00 8:00 100.00 153.00 0.03 4:00 23.00 Unknown 11877 3139.00 14.70 2.00 0.04 6.00 29.00 Unknown 6.00 130.00 173.00 21995 2195.00 34.70 5.00 81.00 90.00 0.04 4,00 29.00 9362 3084.00 15.50 28.00 231.00 0.05 6.00 Unknown 15150 2888.00 63 90 7.00 96,00 122.00 0.03 400 23.00 13327 3361 00 14.10 6.00 4.00 24.00 Europe 16,00 0.04 2676.00 33.00 4 00 100.00 153.00 0.04 400 29.00 Unknow 9831 2460.00 13.70 5.00 110.00 0.04 4,00 30.00 Unknown 11159 141:00 181.00 0.05 4 00 28,00 12295 2592.00 13.10 5.00 110.00 151.00 Unknown 13899 3000.00 16.00 6 00 0.04 29.00 42.60 5:00 93.00 139 00 0.04 4 00 28.00 11731 15.00 6.00 130,0 73.00 Unknown 8419 2643.00 3167.00 0.03 4.00 31.00 2237,00 33.00 5.00 93.00 35.00 0.04 4 00 30 00 Unknow 7371 5.00 74.00 18.00 9131 2235.00 18.40 0.04 4.00 31.00 Unknown 8949 2558.00 33.00 5.00 93.00 135.00 0.04 4.00 28.00 121.00 18040 2433.00 15.20 5.00 96.00 4.00 22.00 Europe 2588.00 15.20 5.00 103.00 132.00 0.04 4 00 27.00 10895 0.05 13276 2735.00 53.00 5.00 125.00 121.00 Europe 25140 24.00 286200 16.30 5.00 150.00 182.00 0.05 400 31 00 Unknow 0.04 9852 56.50 5.00 125.00 121.00 Unknown 21429 2271.00 10.30 5:00 81.00 90,00 0.04 4:00 30.00 3022.00 0.05 6.00 23.00 114.00 ).04 400 3.1.00 8169 12.10 5.00 161.00 163.00 Asia 5666 2222.00 38 50 5.00 90.00 3164.00 35.00 4.00 31.00 7616 21.90 4.00 66.00 73.00 0.04 3.00 Asia 12081 1713.00 26.50 4.00 63.00 81.00 0.04 1745.00 27.00 15851 109.00 0.04 4.00 13831 3779.00 22.40 6,00 150.00 302.00 0.04 8.00 24.00 2240.00 14.90 5.00 90,00 00 30.00 Asia 0.04 2782.00 30:00 4,00 225,00 302.00 0.08 8.00 25.00 11925 11.60 4.00 97.00 109.00 Asia 12158 11458 2455.00 0.04 6,00 30.00 2720.00 40.70 5.00 110.00 133.00 3.04 4.00 29.00 15,40 5.00 115.00 122.00 Asia 9668 11778 2690.00 100 30.00 2982.00 17,00 27.00 0.04 6:00 90.00 53.00 0.03 4 00 Unknown 26.00 Unknown 9722 2207.00 11.00 5.00 90.00 17.00 21498 6.00 24.00 Asia 2515.00 13 20 500 98.00 141.00 12.00 190.00 180.00 0.06 5.00 30.00 Asia 14548 1989.00 11 40 5.00 70.00 90.00 D.04 4.00 33.00 8429 99 3417.00 0.05 1.00 12380 7.80 200 115.00 97,00 23110 2482 00 13 70 5.00 98.00 119.00 10 04 400 30.00 Asia 100 2350,00 0.06 5.00 23.00 92.00 91.00 0 05 4.00 32.00 Asia 10090 4 00 200.00 9008 12 20 3459.00 12.80 180.00 2039.00 5.00 9880 101 89.00 ).04 4.00 32.00 Asia 7640 1819.00 23 20 2.00 92.00 91.00 0 05 4.00 36,00 Asia 102 2025.00 37 80 5.00 78.00 4.00 29.00 Europe 14670 104 57 2522.00 11 20 4 00 104.00 119.00 0.04 4 00 26.00 Asia 2203.00 9.90 109.00 10415 103 81.00 4.00 28.00 Europe 2156.00 11.20 5.00 68.00 90.00 0.03 4.00 31.00 Asia 7634 0.04 Asia 8509 104 2305.00 16.60 5.00 100.00 109.00 24.00 Europe 17820 SS 2011 00 11.40 5.00 70.00 90,00 0.03 4.00 33.00 105 14.00 5.00 114,00 140.00 0.04 4.00 4.00 26.00 Asia 14869 2919.00 0.04 6,00 26.00 Europe 20555 2727.00 29.40 4,00 110 00 137.00 0.04 140.00 4349 106 2954.00 16.80 5.00 114,00 0.03 4 00 31 00 Asia DATA + 107 1832.00 27.50 4.00 64.00 79.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

HW22 2.pdf Adobe Reader File Edit View Window Help 105% open Exercise 1 (Chapter 3 10 Revised This exercise relates to the Cars eat dataset, which can be found in the ISLR package. To begin load in...

(a) Fit a linear regression model to predict Sales using Price, Urban, US, and write out the fitted model in equation form. Note that some of the variables are categorical. (b) Present the summary of...

Download the file Golf.jmp. Use JMP to develop a multiple linear regression model to predict the Earnings/Event using the data found in Golf.jmp. Consider the four independent variables listed in the...

Golf.Imp Golf.imp Source EARNINGS SCORE DRIVE D DRIVE A PUTTS $239.493.68 70.37 288.4 60.2 31.824 $177,249.18 69.43 286.9 67.9 31.302 $218.619.18 70.23 276 71 31.806 $186,380.08 70.46 308.5 56.4...

Please answer the following questions all the information is included organized please... The problem facing a manager is to assess the impact of factors on full-time (FT) job growth. Specifically,...

Case Study Two: WalMa Revenue Due Date: 06:95 Please use DNLY one Excel file to complete this case study, and use one tab for each p Finally, upload the Excel file to the submission link (Week 6 case...

Please help. I created the Linear regresssion models but need assistance on the rest of the questions. PART A (a)Develop a multiple linear regression model to predict Company revenue, using CPI,...

Boreal mixedwood forests have been commercially logged for conifers, transected by roads and seismic cutlines, and regionally fragmented by agricultural practices. Most recently, Alberta's public...

.... Kindly help me understand this problems only 12-106. + Consider the following computer output. (f) Plot the residuals versus y. Are there any indications of The regression equation is inequality...

Ken dilutes 2.15 M of liquid sodium hydroxide (NaOH) in enough distilled water to make 20 mL of stock solution. What volume of this solution and distilled water (DI), when mixed will result in a...

Stahl Company was incorporated as a new business on January 1, 2007. The company is authorized to issue 20,000 shares of $5 par value common stock and 10,000 shares of 6 percent, $10 par value,...

a company spent $ 4 million on research and development for a new project. Should this be taken into account when evaluating whether or not to move forward with the project

Rio Coffee Shoppe sells two coffee drinks, a regular coffee and a latte. The two drinks have the following prices and cost characteristics: Regular Coffee 1.80 0.60 Latte Sales price (per cup)...