Question

In: Statistics and Probability

I want to see if there is a relation between makeup sales and the age of...

I want to see if there is a relation between makeup sales and the age of people buying them on any given day at Sephora. 10 people were randomly sampled.

X-axis: 13, 14, 16, 17, 21, 25, 30, 37, 50, 62 (age)

Y-axis: 2, 7, 30, 26, 15, 33, 7, 3, 14, 1 (Makeup sales)

What is the impact of using a linear regression model in this case? What options, other than linear regression, can you see? You do not need to collect any data.

For your response to a classmate (two responses required, one in each option), examine your classmate’s problem to assess the appropriateness and accuracy of using a linear regression model. Discuss the meaning of the standard error of the estimate and how it affects the predicted values of Y for that analysis.

Solutions

Expert Solution

Given:-

We have data of makeup sales and the age of people buying them on any given day at Sephora for the 10 people.

To do:-

1. Need to check the impact of using linear regression on this data

2. Is there any other technique we can use here?

3. Explain the meaning of Standard Error of the estimate and how it affects the predicted value of y.

Answers:-

1.Linear Regression using Excel Data Analysis.

Type the data>>Data>>Data Analysis>>Regression>>Select input output range>>OK

We can clearly stae that makeup sales is depending upon the age of customer.

Hence Makeup sales(y) is Dependent variable and age(x) is indepndent variable.

So We have to regress Y ~ X

Regression Output is attached here from this we can see that intercept (21.47241) and slope ( -0.269207 )

We can see that from p-value intercept is significant and slope is significant at 29.02 % which is not that much good.

As slope is negative it is clear that age is having negative impact on makeup sales.

Interpretation:- One year increase in age will cause 0.269207 decrease in the makeup scale

Note:- There may be some other variables which are responsible for the makeup sale since R2 and Adj.R2 are very less.

2. Alternative way to get some idea about the relationship is to study the correlation between those variables;

So we will calculate the correlation between age and makeup sales

corr(x,y) = -0.31173

i.e there is negative linear relationship between age and makeup sales

i.e makeup sales is less in the peoples with high age group and vice versa.

3.

Standard Error of the estimated coefficient is nothing but the accuracy measure of that estimate with respect to the corresponding population.It actually measures how far the sample estimate is far from population parameter.

Lower the standard error better is the prediction of the y. As standard error increases the prediced value becomes more un stable.


Related Solutions

What is the relation between stoichiometric coefficient with molar ratios and weight ratios respectively?I WANT A...
What is the relation between stoichiometric coefficient with molar ratios and weight ratios respectively?I WANT A VERY DETAILED ANSWER.
I would like to know the relation between theta changing the Philips curve relation. I have...
I would like to know the relation between theta changing the Philips curve relation. I have concluded the following situations: 1. When theta equals zero, we get the original Phillips curve, a relation between the inflation rate and the unemployment rate; 2. When theta is positive, the inflation rate depends not only on the unemployment rate, but also on last year's inflation rate; 3. When theta equals to 1, we get a modified Philips curve, and the relation becomes that...
A doctor wanted to determine whether there is a relation between a​ male's age and his...
A doctor wanted to determine whether there is a relation between a​ male's age and his HDL​ (so-called good) cholesterol. The doctor randomly selected 17 of his patients and determined their HDL cholesterol. The data obtained by the doctor is the in the data table below. Complete parts​ (a) through​ (f) below. Age, x HDL Cholesterol, y Age, x HDL Cholesterol, y 38 56 39 46 44 56 65 64 45 32 28 52 33 57 53 37 53 37...
A doctor wanted to determine whether there is a relation between a​ male's age and his...
A doctor wanted to determine whether there is a relation between a​ male's age and his HDL​ (so-called good) cholesterol. The doctor randomly selected 17 of his patients and determined their HDL cholesterol. The data obtained by the doctor is the in the data table below. Age_-_x   HDL Cholesterol_-_y 36   58 44   56 46   33 30   55 57   36 52   42 62   42 60   39 25   48 38   44 68   60 28   52 52   34 27   47 53   39 47  ...
A doctor wanted to determine whether there is a relation between a​ male's age and his...
A doctor wanted to determine whether there is a relation between a​ male's age and his HDL​ (so-called good) cholesterol. The doctor randomly selected 17 of his patients and determined their HDL cholesterol. The data obtained by the doctor is the in the data table below. Complete parts​ (a) through​ (f) below. Data: Age, x,  HDL Cholesterol, y 36   56 41   55 47   32 30   56 54   37 51   40 59   40 61   39 25   47 36   43 65   61 29  ...
A doctor wanted to determine whether there is a relation between a male’s age and his...
A doctor wanted to determine whether there is a relation between a male’s age and his HDL (so-called good cholesterol). He randomly selected 9 of his patients and determined their HDL cholesterol. The data is reported in the table below: Age (Yrs) HDL (LaTeX: \mu μ mol/L) 38 57 42 54 46 34 32 56 55 35 52 40 61 42 61 38 26 47 a) Compute the regression equation for HDL as a function of age. b)Interpret the meaning...
A doctor wanted to determine whether there is a relation between a​ male's age and his...
A doctor wanted to determine whether there is a relation between a​ male's age and his HDL​ (so-called good) cholesterol. The doctor randomly selected 17 of his patients and determined their HDL cholesterol. The data obtained by the doctor are in the accompanying data table. Complete parts​ (a) through​ (f) below. 1. Click the icon to view the data obtained by the doctor. 2. Click the icon to view the​ Student's t-distribution table. ​(a) Draw a scatter diagram of the​...
A doctor wanted to determine whether there is a relation between a​ male's age and his...
A doctor wanted to determine whether there is a relation between a​ male's age and his HDL​ (so-called good) cholesterol. The doctor randomly selected 17 of his patients and determined their HDL cholesterol. The data obtained by the doctor is the in the data table below. Company   Compensation   Return A   14.98   74.48 B   4.61   63.62 C   6.15   148.21 D   1.11   30.35 E   1.54   11.94 F   3.28   29.09 G   11.06   0.64 H   7.77   64.16 I   8.23   50.41 J   4.47   53.19 K  ...
Test to see if there is a linear correlation between Age and Balance on a Visa...
Test to see if there is a linear correlation between Age and Balance on a Visa card. Then predict the Balance for a person that is 30 years old. The data collected below comes from people that live in Salinas. Listed below are the genders, ages and current balance on one specific type of Visa card. Gender Balance Age M 235 19 M 122 24 M 1752 55 M 1543 62 M 1655 34 M 0 19 M 84 22...
A study of 11 patients is performed to see if there is correlation between age and...
A study of 11 patients is performed to see if there is correlation between age and length of stay in a hospital for a certain infectious disease. Patient 1 is 24 years old, patient 2 is 30 years old, and continuing in order of patient number, 34, 50, 53, 59, 66, 69, 75, 84, 88 years old. Patient 1 stayed in the hospital 7 days, patient 2 stayed 8 days, and, continuing in order of patient number, 10, 6, 14,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT