Reference no: EM13949817
|
Week
|
Fuel Consumption
|
Average HourlyTemperature
|
Chill Index
|
|
Y
|
X1
|
X2
|
|
(MMcf)
|
(0F)
|
|
|
1
|
30
|
28
|
10
|
|
2
|
25
|
30
|
12
|
|
3
|
22
|
32
|
15
|
|
4
|
18
|
39
|
18
|
|
5
|
15
|
42
|
18
|
|
6
|
12
|
45
|
20
|
|
7
|
10
|
55
|
18
|
|
8
|
10
|
52
|
25
|
|
9
|
9
|
45
|
22
|
|
10
|
7
|
35
|
26
|
Tools/Data Analysis/Regression
Y variable cell range
X variable cell range
check label box, residual plot box and line fit plot
The following problems are to be solved by Excel and/or MegaStat. You need to find the values on the excel regression solutions and interpret them. Part 1 is a simple linear regression as done in the chapter 13 assignment. You should only include Y (fuel consumption) and X1 (temperature) for this analysis. Part 2 is a multiple regression and its solution is just an extension of the linear regression solution. Now you should enter the Y values and both of the X values at the same time. Be sure to include your regression solutions/printouts in your submission using copy/paste.
It was felt by the local utility company that fuel consumption (natural gas) in their small town would be affected by temperature. The following data (ordered by Fuel consumption) was collected for 10 weeks during the winter. FIRST, conduct a linear regression analysis between fuel consumption, Y, and temperature, X1, using Excel or MegaStat. Use alpha = 0.05 and 1.01 for t-tests.
a. What is the Bivariate regression equation using only the first two variables? Interpret it and predict fuel consumption at temperature equal to 50 degrees.
b. Is the slope coefficient in the linear regression model between temperature and fuel consumption statistically significant at alpha=.05 and 0.01? How do you know? Show your test.
c. What is the value of the correlation coefficient, (r)? Interpret. What is the value of the coefficient of determination, R2? Interpret. What is the value of the standard error of the estimate, se?
|
Application of citric acid
: The U.S. Food and Drug Administration (FDA) has long permitted the application of citric acid, ascorbic acid, and other substances to keep fresh meat looking red longer. In 2002, the FDA began allowing meat to be treated with carbon monoxide.
|
|
Publications of disciplines
: The second law of thermodynamics is sometimes cited in publications of disciplines far removed from engineering and science, including but not limited to philosophy, economics, and sociology.
|
|
Power cycles operating between the same
: Answer the following true or false. Explain. (a) The second Carnot corollary states that all power cycles operating between the same two thermal reservoirs have the same thermal efficiency.
|
|
Convert the first normal form to second normal form
: Convert each of the previously identified entities to third normal form. Make certain that the necessary foreign keys have been added to the final tables to support the relationship shown on your initial ER model.
|
|
What is the value of the coefficient of determination, r2
: Is the slope coefficient in the linear regression model between temperature and fuel consumption statistically significant at alpha=.05 and 0.01? How do you know? Show your test.
|
|
Maximum thermal efficiency of any power cycle
: The maximum thermal efficiency of any power cycle operating between hot and cold thermal reservoirs at 10008C and 5008C, respectively, is 50%.
|
|
Problem regarding the isothermal compression
: One-tenth kilogram of air as an ideal gas with k 5 1.4 executes a Carnot refrigeration cycle, as shown in Fig. 5.16. The isothermal expansion occurs at 2238C with a heat transfer to the air of 3.4 kJ. The isothermal com..
|
|
What level of concurrency is best supported by mimd computer
: Could someone please explain to me what are the three levels of concurrency in programs?
|