Question

In: Statistics and Probability

64. FILE Refer to the Lincolnville School bus data. Develop a regression equation that ex presses...

64. FILE Refer to the Lincolnville School bus data. Develop a regression equation that ex presses the relationship between age of the bus and maintenance cost. The age of the bus the Independent variable a. Draw a scatter diagram. What does this diagram suggest as to the relationship be tween the two variables? Is it direct or indirect? Does it appear to be strong or weak? b. Develop a regression equation. How much does an additional year add to the main tenance cost. What is the estimated maintenance cost for a year-old bus? . Conduct a test of hypothesis to determine whether the slope of the regression line is greater than zero . Use the significance level. Interpret your findings from parts (a) , (b), and (c) a brief report.

Can you present the answers in the form of a report?

Solutions

Expert Solution


Related Solutions

Using the data in the Excel file under the tab Problem1, develop a regression equation for...
Using the data in the Excel file under the tab Problem1, develop a regression equation for a country’s lung cancer death rate based on cigarette consumption. Is this a good regression model?  Why or why not? If Cigarette Consumption was 725, what would you predict the Lung Cancer Death Rate to be? Using your regression model, what is the Residual Value for Finland? Do you think there are any outliers in the model?  If so, what would you do with them? Country...
Refer to the Lincolnville School District bus data. 1. Refer to the maintenance cost variable. The...
Refer to the Lincolnville School District bus data. 1. Refer to the maintenance cost variable. The mean maintenance cost for last year is $4,552 with a standard deviation of $2,332. Estimate the number of buses with a maintenace cost of more than $6,000. Compare that with the actual number. Create a frequency distribution of maintenance cost. Is the distribution normally distributed? 2. Refer to the variable on the number of miles driven since the lastm maintenance. The mean is 11,121...
Develop a scatter diagram for these data. Develop the estimated regression equation.
Given the following: X: 1    2    3 4    5 Y: 3    7    5    11    14 Develop a scatter diagram for these data. Develop the estimated regression equation. Use the estimated regression equation to predict the value of Y when X = 4
Refer to the Buena School District bus data ( 2012). Select the variable referring to the...
Refer to the Buena School District bus data ( 2012). Select the variable referring to the number ofmiles traveled last month, and then organize these data into a frequency distribution. a. What is a typical amount of miles traveled? What is the range? b. Comment on the shape of the distribution. Are there any outliers in terms of milesdriven? c. Draw a cumulative frequency distribution. Forty percent of the buses were driven fewerthan how many miles? How many buses were...
Refer to the Lincolnville School District bus data. Conduct a test of hypothesis to reveal whether...
Refer to the Lincolnville School District bus data. Conduct a test of hypothesis to reveal whether the mean maintenance cost is equal for each of the bus manufacturers. Use the .01 significance level. Conduct a test of hypothesis to determine whether the mean miles traveled since the last maintenance is equal for each bus manufacturer. Use the .05 significance level. Show work in Excel. ID Manufacturer Engine Type Engine Type (0=diesel) Capacity Maintenance cost Age Odometer Miles Miles 122 Bluebird...
Using the data in the Excel file Home Market Value, develop a multiple regression model for...
Using the data in the Excel file Home Market Value, develop a multiple regression model for estimating the market value as a function of house age and house size. Predict the value of a house that is 30 years old and has 1800 square feet, and also predict the value of a house that is 5 years old and has 2800 square feet. Conduct your analysis using the following Multiple Regression Model Building and Interpretation Rubric: Identify the dependent variable...
a. Develop an estimated regression equation for the data of the form y-hat = bo + b1 x.
Consider the following data for two variables, X and Y X 6 29 21 15 24 Y 10 30 22 14 25 a. Develop an estimated regression equation for the data of the form y-hat = bo + b1 x. Comment on the adequacy of this equation for predicting y . Enter negative value as negative number. The regression equation is Y = [          ] + [            ] X (to 2 decimals)   S = [       ] (to 3 decimals)...
Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger...
Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger X1 X2 X3 X4 X5 X6 X7 135 329 7 853 Diesel Bluebird 55 Passenger 200 505 10 822 Diesel Bluebird 55 Passenger 40 466 10 865 Gasoline Bluebird 55 Passenger 387 422 8 869 Gasoline Bluebird 55 Passenger 326 433 9 848 Diesel Bluebird 55 Passenger 861 474 10 845 Gasoline Bluebird 55 Passenger 122 558 10 885 Gasoline Bluebird 55 Passenger 887...
Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger...
Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger X1 X2 X3 X4 X5 X6 X7 135 329 7 853 Diesel Bluebird 55 Passenger 200 505 10 822 Diesel Bluebird 55 Passenger 40 466 10 865 Gasoline Bluebird 55 Passenger 387 422 8 869 Gasoline Bluebird 55 Passenger 326 433 9 848 Diesel Bluebird 55 Passenger 861 474 10 845 Gasoline Bluebird 55 Passenger 122 558 10 885 Gasoline Bluebird 55 Passenger 887...
Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger...
Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger X1 X2 X3 X4 X5 X6 X7 135 329 7 853 Diesel Bluebird 55 Passenger 200 505 10 822 Diesel Bluebird 55 Passenger 40 466 10 865 Gasoline Bluebird 55 Passenger 387 422 8 869 Gasoline Bluebird 55 Passenger 326 433 9 848 Diesel Bluebird 55 Passenger 861 474 10 845 Gasoline Bluebird 55 Passenger 122 558 10 885 Gasoline Bluebird 55 Passenger 887...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT