Question # 1                                                                                                                    A well-known multinational FMCG produces more than fifty products and sells them in the market. Out of fifty products one is mineral water for drinking purpose and supplies different size pack bottles in the market. Product manager observed that, during hot days the sale of water is more as compared to the normal days.  He started the collection of data of weekly sale of water and the average weekly temperature. Product manager was interested in developing a relationship between sales and temperature; therefore, he discussed and shared the following data with you. sales 75 77 69 63 79 80 77 70 73 87 72 73 80 80 69 84 77 72 74 81 temperature 32 36 31 31 34 29 32 35 28 31 30 31 29 35 36 28 32 33 32 33   Sale is in thousand liters and temperature is in degree Celsius. Data is Normally distributed   You are required to determine the following information for some concrete decision:   Determine the statistical relationship between temperature and sale of water and interpret. How much change in sales if the temperature increases by two degrees? If for instance, the temperature becomes zero then how much sales will be? How much percent variation in sales due to temperature and due to other factors? Write the equation for the prediction of sales.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.5: Correlation And Causation
Problem 15PPS
icon
Related questions
icon
Concept explainers
Question

Question # 1                                                                                                                   

A well-known multinational FMCG produces more than fifty products and sells them in the market. Out of fifty products one is mineral water for drinking purpose and supplies different size pack bottles in the market. Product manager observed that, during hot days the sale of water is more as compared to the normal days.  He started the collection of data of weekly sale of water and the average weekly temperature.

Product manager was interested in developing a relationship between sales and temperature; therefore, he discussed and shared the following data with you.

sales

75

77

69

63

79

80

77

70

73

87

72

73

80

80

69

84

77

72

74

81

temperature

32

36

31

31

34

29

32

35

28

31

30

31

29

35

36

28

32

33

32

33

 

Sale is in thousand liters and temperature is in degree Celsius. Data is Normally distributed

 

You are required to determine the following information for some concrete decision:

 

  1. Determine the statistical relationship between temperature and sale of water and interpret.
  2. How much change in sales if the temperature increases by two degrees?
  3. If for instance, the temperature becomes zero then how much sales will be?
  4. How much percent variation in sales due to temperature and due to other factors?
  5. Write the equation for the prediction of sales.  

 

Expert Solution
Step 1

“Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for you. To get remaining sub-part solved please repost the complete question and mention the sub-parts to be solved.”

Let (X,Y) be the bivariate distribution where Y is the dependent and X is the independent variable. The line of regression is the line which gives the best estimate to the values of one variable for the specific value of the other variable. The line of regression is obtained by the principle of least square. The equation of the line of regression of Y on X is given as:

Y=a+bX

Here, a and b are constants obtained as:

a=i=1nyinb=xii=1nyixi2i=1n

Step 2

(1.) Let X denotes temperature and Y denotes sales. Here, n=20.

Calculation Table:

xi yi xi2 xiyi
32 75 1024 2400
36 77 1296 2772
31 69 961 2139
31 63 961 1953
34 79 1156 2686
29 80 841 2320
32 77 1024 2464
35 70 1225 2450
28 73 784 2044
31 87 961 2697
30 72 900 2160
31 73 961 2263
29 80 841 2320
35 80 1225 2800
36 69 1296 2484
28 84 784 2352
32 77 1024 2464
33 72 1089 2376
32 74 1024 2368
33 81 1089 2673
Total 1512 20466 48185

 

Step 3

Using above calculation table, we get

a=i=1nyin=151220=75.6b=xii=1nyixi2i=1n=4818520466=2.3544

steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
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.
Recommended textbooks for you
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
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning