Beachcomer Ltd is a local car dealership that sells used and new vehicles. The manager of the company wants to know how different variables affect the sales of his vehicles. A random sample of yearly data was taken with the view to testing the model. SALES = a+BAGE + yMIL + SENG
Where SALES = amount that a vehicle is sold for (000's), AGE = age of vehicle, MIL= the total mileage of the vehicle at the point of sale and ENG = the size of the engine. The sample of data was processed using MINITAB and the following is an extract of the output obtained:
The regression equation is *****
Coef StDev t-ratio p-value
Predictor
Constant 1.7586 0.2525 6.9648 0.0000
AGE 0.2124 0.3175 * 0.5042
MIL -0.7527 0.3586 -2.0991 **
ENG 4.8124 0.6196 7.7664 0.0000
R-sq= 56.1 % R-sq (adj) = 59.8 %
Analysis of Variance
Source DF SS MS F P
Regression 3 413.1291 138.7097 *** 0.00
Error 50 457.7607 2.2888
Total 53
Beachcomer Ltd is a local car dealership that sells used and new vehicles. The manager of the company wants to know how different variables affect the sales of his vehicles. A random sample of yearly data was taken with the view to testing the model. SALES = a+BAGE + yMIL + SENG
Where SALES = amount that a vehicle is sold for (000's), AGE = age of vehicle, MIL= the total mileage of the vehicle at the point of sale and ENG = the size of the engine. The sample of data was processed using MINITAB and the following is an extract of the output obtained:
The regression equation is *****
Coef StDev t-ratio p-value
Predictor
Constant 1.7586 0.2525 6.9648 0.0000
AGE 0.2124 0.3175 * 0.5042
MIL -0.7527 0.3586 -2.0991 **
ENG 4.8124 0.6196 7.7664 0.0000
R-sq= 56.1 % R-sq (adj) = 59.8 %
Analysis of Variance
Source DF SS MS F P
Regression 3 413.1291 138.7097 *** 0.00
Error 50 457.7607 2.2888
Total 53
Hence test whether Delta is significant. Give reasons for your answer
Step by stepSolved in 3 steps with 1 images
- The following regression equation is based on the analysis of four variables: SM_DOLLARS is the dollar amount of a watershed conservation agency's weekly spending on social media ads. RADIO_ADS is the number of radio advertisements aired weekly by the agency. WS_DOLLARS is the dollar amount of the agency’s weekly spending on web search ads. The variable WEB_VISITS is the number of weekly visitors to their educational website. These data have been recorded every week for the past three years. WEB_VISITS (expected) = 109 + 0.2*SM_DOLLARS + 1.5*RADIO_ADS + 1.1*WS_DOLLARS The data meet the assumptions for regression analysis, and the regression results, including the coefficients, were found to be statistically significant. How many additional weekly web visits would you predict when the agency increases its weekly spending on social media ads by $150 without changing the amount spent on radio ads or web search ads? (Round your answer to the nearest whole number.)arrow_forwardWrite down the different Multiple Regression Equations?arrow_forwardA patient is classified as having gestational diabetes if their average glucose level is above 140 milligrams per deciliter (mg/dl) one hour after a sugary drink is ingested. Rebecca's doctor is concerned that she may suffer from gestational diabetes. There is variation both in the actual glucose level and in the blood test that measures the level. Rebecca's measured glucose level one hour after ingesting the sugary drink varies according to the Normal distribution with μ=140+5 mg/dl and σ=5+1 mg/dl. Using the Central Limit Theorem, determine the probability of Rebecca being diagnosed with gestational diabetes if her glucose level is measured: Once? n=5+2 times n=5+4 times Comment on the relationship between the probabilities observed in (a), (b), and (c). Explain, using concepts from lecture why this occurs and what it means in context.arrow_forward
- The following regression equation is based on the analysis of four variables: SM_DOLLARS is the dollar amount of a watershed conservation agency's weekly spending on social media ads. RADIO_ADS is the number of radio advertisements aired weekly by the agency. WS_DOLLARS is the dollar amount of the agency’s weekly spending on web search ads. The variable WEB_VISITS is the number of weekly visitors to their educational website. These data have been recorded every week for the past three years. WEB_VISITS (expected) = 208 + 1.5*SM_DOLLARS + 0.5*RADIO_ADS + 0.8*WS_DOLLARS The data meet the assumptions for regression analysis, and the regression results, including the coefficients, were found to be statistically significant. How many additional weekly web visits would you predict when the agency increases its weekly spending on social media ads by $108 without changing the amount spent on radio ads or web search ads? (Round your answer to the nearest whole number.)arrow_forwardWhat are two variables that will be can be used in a chi-square analysis based in social work? What would the best attributes be for each variable?arrow_forwardYou are a big soccer fan and you decide to gather information on the goal differential (goals scored - goals allowed) for your favorite team in the Premier League during the last season. You find that the average goal differential for home games (games that take place on the team's own stadium) was 1.37 and the average goal differential for away games (games that take place on the opponent team's stadium) was 0.32. With the data you have, if you regress goal differential (call it variable G) on a dummy variable (call it variable D) that takes the value 1 if the game is a home game and takes the value zero if the game is an away game, and obtain Ĝi = Bo + B₁ D₁, then, Bo will be equal to equal to and ₁ will bearrow_forward
- Why the regression line is a straight line rather than a curved line?arrow_forwardWould the regression in Equation be useful for predicting test scoresin a school district in Massachusetts? Why or why not?arrow_forwardABC company has recently experienced a sharp decline in its stock price. Its current (time 0) stock price is $42.65, and this morning, it paid $5.00 per share. Given that the stock price four years ago was $82.88, complete the following time series of data by determining the missing values. t= -3, Pt =$83.43, Divt = $16.03, Rt = (1)t= -2, Pt =$85.20, Divt =(2), Rt = 22.8482%t= -1, Pt =(3), Divt =$17.50, Rt = 20.6572%t= 0, Pt =$42.65, Divt =$5.00, Rt =(4)arrow_forward
- A car lot wants to predict the # of car accessories they need to sell monthly based on the number of cars sold. The car lot owner randomly selects 12 months of data. The simple linear regression equation is ý = 14 - 2x. The coefficient of determination is 0.6364. What is the correlation coefficient to describe the relationship between these two variables? Multiple Choicearrow_forwardA frequent flyer was interested in the relationship between dollars spent on flying and the distance flown. She sampled 20 frequent flyers of a certain airline. She collected the number of miles flown in the previous year and the total amount of money the flyer spent. A regression line of distance flown on money spent was fit to the data: y^=24000+10x. One person in the sample spent $3000 and flew 42,567 miles. What would be the residual (or error) in the predicted distance this person would fly?arrow_forwardDescribe the correlation coefficient and explain how it is used in regression analysis?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