The electric energy consumed each month by a manufacturingwarehouse is imagined to be linked to the ambient temperature, the number of days monthly, average product concentration, and products produced. The annual data based on last year are presented in the following table: a.  Identify the dependent and independed variable then estimate the multiple regression equation. b. What is the r-squared value and what is its implication? c. What variable/s are considered significant? What is the p-value?

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter4: Polynomial And Rational Functions
Section4.6: Rational Functions
Problem 11SC: Find the mean hourly cost when the cell phone described above is used for 240 minutes.
icon
Related questions
Question
100%

APPLIED STATISTICS 

UPVOTE WILL BE GIVEN. PLEASE ANSWER THE PROBLEM BY USING SPSS OR EXCEL ONLY (NOT HANDWRITTEN). NO LONG EXPLANATION NEEDED. TAKE A SCREENSHOTS AND ANSWER THE QUESTION IN SENTENCES.

 

The electric energy consumed each month by a manufacturingwarehouse is imagined to be linked to the ambient temperature, the number of days monthly, average product concentration, and products produced. The annual data based on last year are presented in the following table:

a.  Identify the dependent and independed variable then estimate the multiple regression equation.

b. What is the r-squared value and what is its implication?

c. What variable/s are considered significant? What is the p-value?

Ambient
Temperature
25
31
45
60
65
72
80
84
75
60
50
38
Number of Days Average Product
Concentration
Monthly
24
91
21
90
24
88
87
91
25
25
26
25
25
24
25
25
23
94
87
86
88
91
90
89
Electric Energy
240
236
290
274
301
316
300
296
267
276
288
261
Products
Produced
100
95
110
88
94
99
97
96
110
105
100
98
Transcribed Image Text:Ambient Temperature 25 31 45 60 65 72 80 84 75 60 50 38 Number of Days Average Product Concentration Monthly 24 91 21 90 24 88 87 91 25 25 26 25 25 24 25 25 23 94 87 86 88 91 90 89 Electric Energy 240 236 290 274 301 316 300 296 267 276 288 261 Products Produced 100 95 110 88 94 99 97 96 110 105 100 98
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning