Question

In: Accounting

Question: In a small scale market study investigating brand liking (Y) for product variations with differen......

Question: In a small scale market study investigating brand liking (Y) for product variations with differen...

In a small scale market study investigating brand liking (Y) for product variations with different moisture content (X1) and sweetness (X2), the following data were obtained.

Product

Variation

Moisture

Content

Sweetness

Liking

1

4

2

64

2

4

4

73

3

4

2

61

4

4

4

76

5

6

2

72

6

6

4

80

7

6

2

71

8

6

4

83

9

8

2

83

10

8

4

89

11

8

2

86

12

8

4

93

13

10

2

88

14

10

4

95

15

10

2

94

16

10

4

100

Problem: Regress Liking on each of the other two factors independently. Regress Liking on both of the two other factors simultaneously. Discuss results. Based on the multiple regression, what would the expected liking for a product variation that includes 7 moisture content and 5 sweetness? Is this a valid expectation? Why or why not?

Solutions

Expert Solution

We have analyzed the data provided using the regression feature from Microsoft Excel (Available in the data analysis section).

The result of moisture as independent factor is shown below.

In the results, the key statistics that we need to look at is the R square value. This value varies from 0 to 1 and the close it is to 1 it shows a higher degree of impact on the dependent variable.

In addition to this we should also look at the standard error value. The lower this value, the better suited is the regression line.

Based on the result we can see that the R square value of multiple regression is 0.94. This makes it an extremely good model to predict the likely dependent variable. On the other hand the simple linear regression on individual factors show values of 079 and 015 for Moisture and Sweetness respectively. This shows that Moisture has more role to play than sweetness in the king of the product.

In addition we see that the standard error of multiple regression is much lower at the value of 269. Thus the fitment of regression line drawn from the multiple regression equation is good.

The equation that we can make from these results is (rounding to 1 decimal place)

Y = 37.6 + 4.4 X1+ 42 X2

With this equation we can predict the liking for 7 moisture content and 5 sweetness. It will be

Y=37.6 + 44*7 +4.3*5= 89.9

This is a valid expectation as the R square value is high and the standard error of the regression is low. We can expect the actual result to be very close to this value.


Related Solutions

In a small-scale experimental study of the relation between degree of brand liking (y) and moisture...
In a small-scale experimental study of the relation between degree of brand liking (y) and moisture content (x1) and sweetness (x2) of the product, results were obtained from the experiment based on a completely randomized design. The data is in the Quiz3.xlsx file (Tab Experiment). x1 and x2 are indices and have no units of measurements. Fit a regression model of the form y = beta0 + beta1 x1 + beta2 x2 + e. Here, e is the random error...
In a small-scale experimental study of the relation between degree of brand liking (y) and moisture...
In a small-scale experimental study of the relation between degree of brand liking (y) and moisture content (x1) and sweetness (x2) of the product, results were obtained from the experiment based on a completely randomized design. Fit a regression model of the form y = beta0 + beta1 x1 + beta2 x2 + e. Here, e is the random error term which is assumed to be normally distributed with mean 0 and constant variance. y x1 x2 64 4 2...
In a small-scale experimental study of the relation between degree of brand liking (y) and moisture...
In a small-scale experimental study of the relation between degree of brand liking (y) and moisture content (x1) and sweetness (x2) of the product, results were obtained from the experiment based on a completely randomized design. The data is in the Quiz3.xlsx file (Tab Experiment). x1 and x2 are indices and have no units of measurements. Fit a regression model of the form y = beta0 + beta1 x1 + beta2 x2 + e. Here, e is the random error...
A study investigating the relationship between blood pressure rise in millimetre of mercury (y) and the...
A study investigating the relationship between blood pressure rise in millimetre of mercury (y) and the sound pressure level in decibels (x). Use the correlation and regression technique to investigate the relationship between the variables. x 1 0 1 2 5 1 4 6 y 60 63 65 70 70 70 80 90
A chemical engineer is investigating the effect of process operating temperature on product yield. The study...
A chemical engineer is investigating the effect of process operating temperature on product yield. The study results in the following data: Temperature Yield 100 56.17 110 72.28 120 75.68 130 73.30 140 90.95 150 90.21 160 103.68 170 114.28 180 123.66 190 130.66 You can use Minitab to answer the following questions. However, you should be able to calculate the slope and intercept of the least squares regression model by hand, which requires only the means and standard deviations of...
A chemical engineer is investigating the effect of process operating temperature on product yield.The study results...
A chemical engineer is investigating the effect of process operating temperature on product yield.The study results in the following data: Temperature Yield 100 59.63 110 72.28 120 70.98 130 74.35 140 88.23 150 100.28 160 106.41 170 113.01 180 113.71 190 124.07 You can use Minitab to answer the following questions. However, you should be able to calculate the slope and intercept of the least squares regression model by hand, which requires only the means and standard deviations of X...
A chemical engineer is investigating the effect of process operating temperature on product yield.The study results...
A chemical engineer is investigating the effect of process operating temperature on product yield.The study results in the following data: Temperature Yield 100 61.07 110 66.01 120 79.28 130 75.04 140 80.30 150 97.95 160 98.17 170 110.07 180 121.28 190 118.21 You can use Minitab to answer the following questions. However, you should be able to calculate the slope and intercept of the least squares regression model by hand, which requires only the means and standard deviations of X...
From: The Right to Food Sovereignty for Small Scale Farmers: Case Study of Farming Cooperatives in...
From: The Right to Food Sovereignty for Small Scale Farmers: Case Study of Farming Cooperatives in Limpopo Province, South Africa. by: Sharon Groenmeyer Food sovereignty is defined as the fundamental democratic right to shape agricultural and food policy from the bottom up. Africa is the hardest hit by climate change because it depends on natural resources where small-scale agriculture is the dominant method of food production, except in South Africa where commercial agriculture dominates. This has direct links to climate...
A recent small-scale study surveyed 300 men and women to ask “What automobile is attractive to...
A recent small-scale study surveyed 300 men and women to ask “What automobile is attractive to you?” and asked them to choose from the five options below. Results of the survey are presented in the table. Conduct a test at the alpha=0.01 level to ascertain whether there is a difference in the pattern of responses between men and women consumers. Auto Brand Men Women Ford F-150 10 40 Mini Cooper 0 60 Geo Metro 60 0 Hyundai Genesis 40 10...
A recent small-scale study surveyed 300 men and women to ask “What automobile is attractive to...
A recent small-scale study surveyed 300 men and women to ask “What automobile is attractive to you?” and asked them to choose from the five options below. Results of the survey are presented in the table. Conduct a test at the alpha=0.01 level to ascertain whether there is a difference in the pattern of responses between men and women consumers. (45 Points) Auto Brand Men Women Ford F-150 10 40 Mini Cooper 0 60 Geo Metro 60 0 Hyundai Genesis...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT