Solution-Develop a model to predict gasoline usage

Develop a model to predict gasoline usage

Assignment Help Basic Statistics

Reference no: EM131083971

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
27.2	84	2490
39.1	58	1755
28.0	88	2605
24.0	92	2865
20.2	139	3570
20.5	95	3155
28.0	90	2678
34.7	63	2215
36.1	66	1800
35.7	80	1915
20.2	85	2965
23.9	90	3420
29.9	65	2380
30.4	67	3250
36.0	74	1980
22.6	110	2800
36.4	67	2950
27.5	95	2560
33.7	75	2210
44.6	67	1850
32.9	100	2615
38.0	67	1965
24.2	120	2930
38.1	60	1968
39.4	70	2070
25.4	116	2900
31.3	75	2542
34.1	68	1985
34.0	88	2395
31.0	82	2720
27.4	80	2670
22.3	88	2890
28.0	79	2625
17.6	85	3465
34.4	65	3465
20.6	105	3380

Reference no: EM131083971

Questions Cloud

Test concerning proportions : Twenty one out of 100 randomly selected women said they use seat belts, while 117 out of 180 men said the same. Test the claim that men are more safety conscious than women based one the use of seat belts at a 0.01 level of significance. Construct..

Sequence of independent samples of a random variable : Let X1, X2,... denote a sequence of independent samples of a random variable X with variance Var[X]. We define a new random sequence Y1, Y2,... as

Determining the number of employees : The state office of Australia Post believed that mail throughput at suburban post offices increases with the number of employees. From a random sample of ten major suburban post offices, the following regression equation was estimated: Y = -11.76 ..

Determine the dominant frequency component : Vibration signal of the acceleration response from a simple supported beam ("vbrdata.dat"), sampling rate = 1,000 Hz. From the spectral plot, determine four dominant frequencies (modes).

Develop a model to predict gasoline usage : 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.

Generate the sum of sinusoids for 240 samples : Generate the sum of sinusoids for 240 samples using a sampling rate of 8,000 Hz.

If you were ceo at disney-what would you do : MGMT 1100, CH 6 - how should Disney's different entertainment areas be managed? Should there be one grand strategy (i.e., growth, stability, retrenchment) that every division follows, or should each division have a focused strategy for its own mar..

Find the domain all asymptotes- holes and extrema : A large cone shaped funnel of height 5m and radius 3m contains a chemical mixture. The chemical mixture is being emptied out of the bottom of the funnel at a rate of 0.5 m3/sec. How fast is the depth of the chemical mixture changing when the depth..

Explore the history of the issue : This project is intended to explore the history of the issue, changes that have occurred and how those changes impact Quality in an organization. The usage of current and historical statistics will be useful in supporting your position and analysi..

User Account

All Pages

Develop a model to predict gasoline usage

Reference no: EM131083971

Reference no: EM131083971

Questions Cloud

Reviews

Write a Review

Basic Statistics Questions & Answers

Statistics-probability assignment

What is the least number

Determine the value of k

What is the probability

Binomial distributions

Caselet on mcdonald’s vs. burger king - waiting time

Generate descriptive statistics

Sampling variability and standard error

Estimate the population mean

Conduct a marketing experiment

Find out the probability

Linear programming models

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT