Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
A US consumer lobby wishes to develop a model to predict gasoline usage, as measured by miles per gallon, based on the weight of the car in pounds. The Excel data file contains data on this for fifty recent models. Use Excel Data Analysis to estimate a linear model for the relationship, a 95% confidence interval for the slope coefficient and a residual plot. State all numerical answers below correct to four decimal places using the Excel output results.
1. the intercept
2. the slope coefficient
3. the standard error of the estimate
4. Using this model, predict the gasoline usage for a car weighing 1200 pounds. Use all decimal places in your calculation by selecting and using the values of b0 and b1 in the output generated by Excel.
5. Does the prediction involve extrapolating the relationship? Type yes or no.
Data:
MPG
Horsepower
Weight
43.1
48
1985
19.9
110
3365
19.2
105
3535
17.7
165
3445
18.1
139
3205
20.3
103
2830
21.5
115
3245
16.9
155
4360
15.5
142
4054
18.5
150
3940
27.2
71
3190
41.5
76
2144
46.6
65
2110
23.7
100
2420
84
2490
39.1
58
1755
28.0
88
2605
24.0
92
2865
20.2
3570
20.5
95
3155
90
2678
34.7
63
2215
36.1
66
1800
35.7
80
1915
85
2965
23.9
3420
29.9
2380
30.4
67
3250
36.0
74
1980
22.6
2800
36.4
2950
27.5
2560
33.7
75
2210
44.6
1850
32.9
2615
38.0
1965
24.2
120
2930
38.1
60
1968
39.4
70
2070
25.4
116
2900
31.3
2542
34.1
68
34.0
2395
31.0
82
2720
27.4
2670
22.3
2890
79
2625
17.6
3465
34.4
20.6
3380
Formulate an appropriate hypothesis test to examine at the 10% level of significance whether the manager's worries are justified.
the state fish and game division claims that 75 of the fish in homestead creek are rainbow trout. however the local
Arizona Plumbing, which makes, among other products, a full line of bathtubs must decide which of its factories should supply which of its warehouses.
Sketch the appropriate distribution, and locate the critical region for a = 0.05.
the average hourly wage of workers at a car wash is 6.50hr. assume the wages are normally distributed with a
Assuming the nurses surveyed were a simple random sample from the population of all nurses in the United States, find the appropriate null hypothesis for these data
To determine whether this difference is significant, you collect data on the seating preferences for the students in your class. A researcher hypothesizes that individuals who listen to classical music will score differently from the general popula..
Suppose the world series is about to begin. Some people get together and each decide to predict different win-loss patterns for the seven possible games during the coming series.
A basketball player shoots 8 free throws during a game. If we assume that each attempt has the same probability of success, the sample space for the number of baskets he/she makes during the game is ??
10 squirrels were found to have an average weight of 9.6 ounces with a sample standard deviation is 0.30. find the 99
For the sample of men, performance on the simulator task declined by an average of 2.9 points with s = 4.1. Is this a statistically significant change? Use a two-tailed test with = .05.
supposed 57 of the registered voters in a country are republican.if a sample of 722 voters is selected what is the
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd