United Oil Company is attempting to develop a reasonably priced unleaded gasoline that will deliver higher gasoline mileages than can be achieved by its current unleaded gasolines. As part of its development process, United Oil wishes to study the effect of two independent variables—x1, amount of gasoline additive RST (0, 1, or 2 units), and x2, amount of gasoline additive XST (0, 1, 2, or 3 units), on gasoline mileage, y. Mileage tests are carried out using equipment that simulates driving under prescribed conditions. The combinations of x1 and x2 used in the experiment, along with the corresponding values of y, are given below. RST Units (x1) XST Units (x2) Gas Mileage (y, mpg) 0 0 27.30 0 0 28.25 0 0 28.61 1 0 29.45 1 0 30.69 2 0 28.26 2 0 29.27 0 1 32.50 0 1 33.55 1 1 33.76 1 1 34.94 0 2 32.73 0 2 33.75 1 2 34.43 1 2 35.45 1 2 35.92 Run the multiple regression analysis based on the given data using the Microsoft Excel. Based on the output, construct an equation that can be used to predict the gasoline mileage based on X1 and X2 Interpret the coefficient of X Is each independent variable playing a significant role in influencing the gasoline mileage? Justify your answer based on P-value approach.

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

Related questions

Question

United Oil Company is attempting to develop a reasonably priced unleaded gasoline that will deliver higher gasoline mileages than can be achieved by its current unleaded gasolines. As part of its development process, United Oil wishes to study the effect of two independent variables—x₁, amount of gasoline additive RST (0, 1, or 2 units), and x₂, amount of gasoline additive XST (0, 1, 2, or 3 units), on gasoline mileage, y. Mileage tests are carried out using equipment that simulates driving under prescribed conditions. The combinations of x₁ and x₂ used in the experiment, along with the corresponding values of y, are given below.

RST Units (x₁)	XST Units (x₂)	Gas Mileage (y, mpg)
0	0	27.30
0	0	28.25
0	0	28.61
1	0	29.45
1	0	30.69
2	0	28.26
2	0	29.27
0	1	32.50
0	1	33.55
1	1	33.76
1	1	34.94
0	2	32.73
0	2	33.75
1	2	34.43
1	2	35.45
1	2	35.92

Run the multiple regression analysis based on the given data using the Microsoft Excel.
Based on the output, construct an equation that can be used to predict the gasoline mileage based on X₁ and X₂
Interpret the coefficient of X
_{Is each independent variable playing a significant role in influencing the gasoline mileage? Justify your answer based on P-value approach.}

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Anova and Design of Experiments$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions