Interpret the following three sets of data (X versus Y) using scatter chart and regression analyzeX: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day) C16C17X: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day)52710462073908408043073287012465960155950464640403027 2830201010152025numbers of cars on the sales lotcars sold per day SUMMARY OUTPUTRegression StatisticsMultiple F 0.984033R Square0.96832Adjusted i 0.96304Standard E 1.052994Observati8ANOVAdfSSMSFgnificance FRegressio1 203.3472 203.3472 183.3946 1.01E-05Residual6 6.652777 1.108796Total7210Coefficientsandard Errt StatP-value Lower 95%Upper 95%ower 95.0%pper 95.0%Intercept -4.542661.13657 -3.99682 0.007145 -7.32375 -1.76157 -7.32375 -1.76157C170.333356 0.024616 13.542331.01E-05 0.273123 0.393589 0.273123 0.393589

Interpret the following set of data (X versus Y) using scatter chart and regression analyze number…

Answered: Interpret the following three sets of…

Interpret the following three sets of data (X versus Y) using scatter chart and regression analyze X: C16 (number of cars on the sales lot) versus Y: C17 (cars sold per day)

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Bluereef real estate agent wants to form a relationship between the prices of houses, how many bedrooms, House size in sq ft and Lot Size in sq ft. The data pertaining to 100 houses were processed using MINITAB and the following is an extract of the output obtained: The regression equation is Price = B + Bedroom + yHouse Size + ALot Size Predictor Coef SE Coef T P Constant 37718 2.66 ** Bedrooms 2306 0.33 74.3 -4.36 House Size Lot Size S-25023 Error Total R-Sq-56.0 % 96 99 14177 6994 52.98 17.02 0.742 0.164 -0.26 0.798 Source DE SS MS F Regression 3 76501718347 25500572782 *** Residual 60109046053 626135896 R-Sq (adj) -54.6% P d) Is y significantly different from -0.5? e) Perform the F test at the 1% level, making sure to state the null and alternative hypoteses. f) Give an interpretation to the term “R-sq” and comment on its value.
The datasetBody.xlsgives the percent of weight made up of body fat for 100 men as well as other variables such as Age, Weight (lb), Height (in), and circumference (cm) measurements for the Neck, Chest, Abdomen, Ankle, Biceps, and Wrist. We are interested in predicting body fat based on abdomen circumference. Find the equation of the regression line relating to body fat and abdomen circumference. Make a scatter-plot with a regression line. What body fat percent does the line predict for a person with an abdomen circumference of 110 cm? One of the men in the study had an abdomen circumference of 92.4 cm and a body fat of 22.5 percent. Find the residual that corresponds to this observation. Bodyfat Abdomen 32.3 115.6 22.5 92.4 22 86 12.3 85.2 20.5 95.6 22.6 100 28.7 103.1 21.3 89.6 29.9 110.3 21.3 100.5 29.9 100.5 20.4 98.9 16.9 90.3 14.7 83.3 10.8 73.7 26.7 94.9 11.3 86.7 18.1 87.5 8.8 82.8 11.8 83.3 11 83.6 14.9 87 31.9 108.5 17.3…
The following data show the brand, price ($), and the overall score for six stereo headphones that were tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). The estimated regression equation for these data is ý = 22.525 + 0.325x, where x = price ($) and y overall score. %3D Brand Price ($) Score 180 78 B. 150 71 C 95 59 70 54 E 70 40 35 28 (a) Compute SST, SSR, and SSE. (Round your answers to three decimal places.) SST SSR %3D SSE = (b) Compute the coefficient of determination . (Round your answer to three decimal places.) 1 = Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.) O The least squares line provided a good fit as a large proportion of the variability in y has been explained by the least squares line. O The least squares line did not provide a good fit as a large proportion of the variability in y…
The 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 40 inches. Is the result close to the actual weight of 352 pounds? Use a significance level of 0.05. Chest size (inches) *Weight (pounds) 44 54 328 528 41 55 39 51 418 580 296 503 Click the icon to view the critical values of the Pearson correlation coefficient r. - What is the regression equation? x (Round to one decimal place as needed.)
The following table shows the starting salary and profile of a sample of 10 employees in a certain call center agency. Run a multiple regression analysis with starting salary as the dependent variable (pesos) and GPA, years of experience and civil service ratings as the independent variables. Use .05 level of significance. Copy-paste the data and run the analysis using MS Excel. starting salary GPA Years of experience Civil Service Ratings 15000 80.1 1 79.5 15000 81.2 1 78.0 15500 81.3 2 79.0 16000 82.4 3 80.0 16200 83.4 3 85.0 17500 87.9 4 89.9 18000 90.3 5 89.1 16300 84.2 3 84.1 17000 87.0 4 89.0 17900 88.1 5 89.2 What is the computed R square of the resulting multiple linear regression and its interpretation?
The arm span and foot length were both measured (in centimeters) for each of 20 students in a biology class. The computer output displays the regression analysis. Which of the following is the best interpretation of the coefficient of determination r2? About 37% of the variation in arm span is accounted for by the linear relationship formed with the foot length. About 65% of the variation in foot length is accounted for by the linear relationship formed with the arm span. About 63% of the variation in arm span is accounted for by the linear relationship formed with the foot length. About 63% of the variation in foot length is accounted for by the linear relationship formed with the arm span.
Develop a scatterplot and explore the correlation between customer age and net sales by each type of customer (regular/promotion). Use the horizontal axis for the customer age to graph. Find the linear regression line that models the data by each type of customer. Round the rate of changes (slopes) to two decimal places and interpret them in terms of the relation between the change in age and the change in net sales. What can you conclude? Hint: Rate of Change = Vertical Change / Horizontal Change = Change in y / Change in x
The following data show the brand, price ($), and the overall score for six stereo headphones that were tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). The estimated regression equation for these data is ŷ = 22.391 + 0.326x, where x = price ($) and y = overall score. Brand Price ($) Score A 180 76 B 150 71 C 95 63 D 70 56 E 70 40 F 35 24 #1) Compute SST, SSR, and SSE. (Round your answers to three decimal places.) SST = SSR = SSE = #2) Compute the coefficient of determination r2.(Round your answer to three decimal places.) r2 = #2a) Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.) A) The least squares line provided a good fit as a small proportion of the variability in y has been explained by the least squares line. B) The least squares line provided a good fit as a large…
The accompanying data represent the weights of various domestic cars and their gas mileages in the city. The linear correlation coefficient between the weight of a car and its miles per gallon in the city is r= - 0.972. The least-squares regression line treating weight as the explanatory variable and miles per gallon as the response variable is y= - 0.0070x + 44.4405. Complete parts (a) and (b) below. Click the icon to view the data table. ..... (a) What proportion of the variability in miles per gallon is explained by the relation between weight of the car and miles per gallon? The proportion of the variability in miles per gallon explained by the relation between weight of the car and miles per gallon is %. (Round to one decimal place as needed.) (b) Interpret the coefficient of determination. % of the variance in is by the linear model. Data Table (Round to one decimal p Full data set gas mileage Miles per Weight (pounds), x Weight (pounds), x Miles per Gallon, y Car Car Gallon, y…
One of the biggest changes in higher education in recent years has been the growth of online universities. The Online Education Database is an independent organization whose mission is to build a comprehensive list of the top accredited online colleges. The following table shows the retention rate (%) and the graduation rate (%) for 29 online colleges.a). Use Excel Data Analysis Tool – Regression to get the relationship between the two variables;b). Create a scatter diagram for the two variables and display regression equation and R square on chart, then explain the relationship between the variables;c). Did the estimated regression equation provide a good fit?d). Suppose you were the president of South University. After reviewing the results, would you be able to use the regression result for forecasting. College RR(%) GR(%) Western International University 7 25 South University 51 25 University of Phoenix 4 28 American InterContinental University 29 32 Franklin…
The following data show the brand, price ($), and the overall score for six stereo headphones that were tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). The estimated regression equation for these data is ŷ = 21.592 + 0.324x, where x = price ($) and y = overall score. Brand Price ($) Score A 180 76 B 150 69 C 95 61 D 70 56 E 70 38 F 35 24 (a) Compute SST, SSR, and SSE. (Round your answers to three decimal places.) (b) Compute the coefficient of determination r2. (Round your answer to three decimal places.) (c) What is the value of the sample correlation coefficient? (Round your answer to three decimal places.)
For 39 nations, a correlation of 0.887 was found between y = Internet use (%) and x = gross domestic product (GDP, in thousands of dollars per capita). The regression equation is y = -3.68 + 1.73x. Complete parts (a) through (c). a. Based on the correlation value, the slope had to be positive. Why? A. The slope and correlation are positive because gross domestic product could not be negative. B. The correlation and the slope are positive because the y-intercept is negative. C. That is a very unusual fact, because the slope and correlation usually have different signs. D. Although slope and correlation usually have different values, they always have the same sign.