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
Perform a paired-samples t-test for experiment (p = .01 or 99% confidence, two-tailed). Is there a significant difference between the two teaching methods?
We use statistical software to do the prediction and obtain the following output. 95% confidence interval for the average profit of companies with 500 units of sales is?
a researcher wishes to compare the effect of the rate of stepping on heart rate in a step-aerobics workout. a
a teacher finds that the scores of a particularly difficult test were normally distributed with a mean of 76 and
MixedNutsis a store that sells a variety of unpackaged dried fruit and nut items. The current amounts of supplies of each item are listed in the following table:
The total cholesterol level of US females 2 years old or older is normally distributed with a mean of 206 mg/dl and a standard deviation of 44.7
Medical Mutual Insurance is investigating the cost of a routine office visit to family-practice physicians in the Rochester, New York, area. The following is a list of family-practice physicians in the region.
The Delphi method solicits input from customers or potential customers regarding their future purchasing plans.
the following is a cross-tabulation taken from a subset of the 2010 general social survey. respondents were asked
a sample of 77 individuals working at a particular construction site office was selected at random. the noise level dba
What course of action would you propose for the statistical analysis if it was learned that Vietnam veteran #646 (the largest observation in Display 3.6) worked for several years, after Vietnam, handling herbicides with dioxin? (b) What would you ..
Let X denote the vibratory stress (psi) on a wind turbine blade at a particular wind speed in a wind tunnel. The article "Blade Fatigue Life Assessment with Application to VAWTS" (J. of Solar Energy Engr., 1982: 107-111) proposes the Rayleigh d..
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