Question

In: Statistics and Probability

Promotional expenses(x) Sales(y 7 12 10 14 9 13 4 5 11 15 5 7 3...

Promotional expenses(x) Sales(y
7 12
10 14
9 13
4 5
11 15
5 7
3 4

a) draw the scatter plot and draw the line of best fit

b) Calculate and interpret the correlation between promotional expenses and sales

C) Calculate the regression equation( calculate the slope and intercept of the regression line

d)Interpret the slop coefficient of regression equation

e)Using the regression equation calculate the sales volume with respect to promotional expense of 4.

f) Obtain the coefficient of determination (how much of the variability of sales is predicted by promotional expenses) and interpret the results

Solutions

Expert Solution

(a) The scatter plot and the line of best fit is as follows.

....................

(b) The correlation coefficient of the aforesaid variables is found to be 0.9787083 (in the R software).

R code:

x=c(7,10,9,4,11,5,3)
y=c(12,14,13,5,15,7,4)
cor(x,y)

A high and positive value of the correlation means the two variables are closely linearly related and one increases with the another more or less.

................................

(c) The regression equation is calculated in the R software by the following commands.

Model<-lm(y~x)
summary(Model)
Output:

Call:
lm(formula = y ~ x)

Residuals:
1 2 3 4 5 6 7
2.0000 -0.2931 0.1379 -0.7069 -0.7241 -0.1379 -0.2759

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -0.01724 1.01585 -0.017 0.987115
x 1.43103 0.13422 10.662 0.000126 ***
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 1.022 on 5 degrees of freedom
Multiple R-squared: 0.9579, Adjusted R-squared: 0.9494
F-statistic: 113.7 on 1 and 5 DF, p-value: 0.0001256
That is the estimated slope coefficient is 1.43103 and the estimated intercept is -0.01724, and the regression line is Y=-0.01724 + 1.43103X.

Since the slope coefficient is too far from 0 and the null hypothesis that slope=0 is rejected with a p-value of 0.000126 (*** marked in the aforesaid output), we can conclude that the model is significant.


Related Solutions

Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...
Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Number of Aides Absent 5 8 11 15 4 2 7 1 4 6 14 19 3 5 8 In which of the following ranges you can find the Upper Control Limit of the control chart? 0.1427 0.1536 0.1677 Not computable with information available In which of the following ranges you can find the Lower Control Limit of the control chart? Does not exit...
student 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...
student 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Test score 67 67 87 89 87 77 73 74 68 72 58 98 98 70 77 Above we have the final averages of the last stats and I want to know if the class average falls within the boundaries of all my statistics classes for the past 20 years. Find the sample size, mean, and standard deviation of the data above (Table 1)....
Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14...
Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Player A 8 42 56 68 91 123 12 46 57 137 5 80 14 10 19 Player B 38 44 46 59 57 61 48 42 51 39 58 41 55 45 68 1. For the given data set representing the runs scored by two players in last 15 matches, conduct the following analysis: i. Which average you will use to summarize...
Company ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14...
Company ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 5330 6352 6340 3399 6566 7376 6882 1842 7362 8205 6222 7695 1681 2283 2 7972 5941 2861 3290 1019 7399 6442 8003 5092 4634 7569 2538 2619 7932 3 8545 6667 2121 2339 4770 7296 3215 7919 2176 9129 1321 695 7945 1673 4 4578 466 4142 8350 7439 6085 8381 5872 2703 6974 702 5846 7176 9179 5 7302 2727 3103...
Given the following data: x 2 8 5 12 9 y 6 11 7 14 10...
Given the following data: x 2 8 5 12 9 y 6 11 7 14 10 a) draw/graph a scatter plot. b) by hand, find the correlation coefficient r. c) by hand, find b0 and b1. d) write the regression equation.
x 3, 4, 5, 7, 8 y 3, 7, 6, 13, 14 (a) Find the estimates...
x 3, 4, 5, 7, 8 y 3, 7, 6, 13, 14 (a) Find the estimates of Bo and B1. Bo=bo= _____ (Round to three decimal places as needed.) B1=b1= ______(Round to four decimal places as needed.) (b) Compute the standard error the point estimate for se= ____ (c) Assuming the residuals are normally distributed, determine Sb1=____ (Round to four decimal places as needed.) (d) Assuming the residuals are normally distributed, test HoB1=0 versus H1:B1/=0 at the a=0.05 level of...
11 12 11 10 14 15 16 12 11 10 12 20 13 32 35 14...
11 12 11 10 14 15 16 12 11 10 12 20 13 32 35 14 41 12 10 11 12 12 13 16 14 17 18 19 12 13 14 10 10 14 11 10 12 14 12 13 16 14 17 19 20 15 25 15 45 45 44 41 40 14 18 19 24 20 26 36 34 30 31 50 15 12 Find the following: Mean? (1) Median (2), and Mode? Find : Q3, Q1, D7,...
Use the sample space (5, 6, 7, 8, 9, 10, 11, 12, 13, 14) to find...
Use the sample space (5, 6, 7, 8, 9, 10, 11, 12, 13, 14) to find the probability for a random selected a) P(integer) b) P(less than 10 | less than 13) c) P(greater than 8 | less than 11) d) P(greater than 7 | greater 12)
3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5...
3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5 8 1 12 14 Each column represents a different treatment given to sick rats. Each cell is a different rat. Use statistical analysis and use post hoc testing using contrasts to find the best treatment. Treatment 1: vitamins Treatment 2: prescription pills Treatment 3: brain surgery Treatment 4: shock therapy Treatment 5: dietary changes
For the data set 1 4 4 4 7 7 7 9 12 13 14 14...
For the data set 1 4 4 4 7 7 7 9 12 13 14 14 14 15 16 16 17 17 19 20 22 23 23 24 24 25 26 26 27 29 29 31 34 34 35 35 36 37 43 44 44 47 48 48 49 50 52 52 54 54 55 56 56 58 58 59 59 60 64 64 65 66 69 69 73 76 76 77 77 79 (a) Find the 76th percentile. (b)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT