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?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman