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
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter9: Sequences, Probability And Counting Theory
Section9.7: Probability
Problem 2SE: What is a sample space?
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
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning