 # Statistical Inference And Regression Analysis 218 Downloads9 Pages 2,243 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

## Question:

1. Use the same data that was used in Assignment 1 which is the SWEETS-4-U2 data for the previous year which consists of 52 weekly values of the sales and costs for the two popular product lines namely Forgive and Rejoice.

These two products are both wrapped chocolates sold by weight. The only difference between Forgive and Rejoice is that different messages are attached to each type of chocolate. The Forgive chocolates have messages like “Sorry”, “Forgive Me” and “Trust Me” and the Rejoice chocolates have messages like “Celebrate”, “Have Fun” and “I Love You”.

The 52 Sales and Cost values for both types of chocolate are given in SWEETS-4-U2.xls.

The Accountant for SWEETS-4-U2 is worried that the business is spending too much on advertising for Rejoice as sales now exceed what the firm has budgeted for. In the business plan the firm had assumed that the average weekly sales for Rejoice was \$450. If sales are more than \$450 then the firm will be able to reduce its advertising spending.

(You can use Excel or your calculator for any calculations.)

[a] Using Excel and the weekly sales data find the mean and standard deviation of Rejoice Sales.

[b] Find the 90% interval estimate of the average weekly sales for Rejoice.

[c] Using a level of significance of a = 0.05 test whether the average of the weekly sales for Rejoice are more than 450.

[d] Briefly explain what a Type I error and what a Type II error are and what are their costs or consequences in this problem.

[e] Find the p value in this situation. Explain what the p value is and how we would use the p value to test the hypotheses.

[f] Using the p value test the hypotheses when the level of significance is a = 0.10

[g] Briefly explain how and when we can use an interval estimate when testing hypotheses.

2. Suppose the Sales manager of the Sweets-4-U2 chain of confectionary stores is interested in the relationship between Sales and Total costs for the Rejoice range of chocolates. i.e. how total cost is affected by sales, for the Rejoice product line.

The 52 Sales and Cost values for both types of chocolate are given in SWEETS-4-U2.xls.

Unless otherwise stated use a level of significance of a = 0.05.)

(You can use Excel or your calculator for any calculations.)

[a]   Obtain the scatter diagram, the covariance and the correlation coefficient for Total Costs and Sales for the Rejoice chocolates. Briefly explain what this graph and these values are telling us about the relationship between Total Costs and Sales

[b]   Write down the two forms of the Population Regression function you would assume here. Briefly explain how we interpret the conditional mean E(Y | X) and the error term (e).

[c]   Estimate the sample regression function. Write down your estimated model and briefly explain what the estimated intercept and estimated slope are telling us about the relationship between the Total Costs and Sales for Rejoice chocolates.

[d]   Using the F statistic, the R-squared value and the p-value for the estimated slope briefly discuss whether this estimated model does or does not show that there is a significant relationship between Total Costs and Sales for Rejoice chocolates.

(With a sample of n = 52 you can assume that the critical values for the t statistic are the same as the critical values for a z statistic.)

[e]   Test the following hypotheses concerning the slope

H0 : b1 = 0.8   and   H1 : b1 > 0.8

[f]   Using you estimated model forecast the Total Costs when Sales are 200. Comment briefly on how useful this forecast will be.

Briefly explain what we mean by the terms “Prediction Interval” and “Confidence Interval”

[g]   Using the F statistic, the R-squared value and the scatter diagram which shows the Residuals on the vertical axis and the values of Sales (our X variable) on the horizontal axis briefly discuss whether our estimated model can be seen as a reliable estimate of the relationship between Total Costs and Sales for Rejoice chocolates.

a) Using Excel and the weekly sales data find the mean and standard deviation of Rejoice Sales.

The mean and standard deviation by using excel is given below: b) Find the 90% interval estimate of the average weekly sales for Rejoice.

The 90% confidence interval estimate of the average weekly sales for rejoice is given in the following table: c) Using a level of significance of a = 0.05 test whether the average of the weekly sales for Rejoice are more than 450.

Here we have to use the one sample t test for the population average of the weekly sales for the Rejoice. The total test with calculations are given below:

Null hypothesis: Population average for weekly sales is \$450.

Alternative hypothesis: Population average for weekly sales is more than \$450.

One sample t test for Rejoice sales d) Here we reject the null hypothesis that the population average for the weekly sales is \$450.

Briefly explain what a Type I error and what a Type II error are and what are their costs or consequences in this problem.

Type I error is nothing but the probability of the rejecting the null hypothesis when it is true and type II error is the probability of the not rejecting the null hypothesis even though it is not true. For this problem, the type I error is the probability of rejecting the null hypothesis that the average of the weekly sales for Rejoice is \$450 when actually it is true that the average of the weekly sales for Rejoice is \$450. The type II error is the probability of not rejecting the null hypothesis that the average of the weekly sales for Rejoice is \$450 when actually it is false that the average of the weekly sales for Rejoice is \$450.

e)

Here we are given a p-value = 0.0833 and we know the following decision rule:

Decision rule: We reject the null hypothesis when the p-value is less than the alpha value or level of significance and we do not reject the null hypothesis when the p-value is greater than the alpha value or level of significance.

Here, we have alpha value = 0.05 and p-value = 0.0833, that is, we have p-value > alpha value, therefore, we do not reject the null hypothesis that the average of the weekly sales for Rejoice is \$450.

f) Using the p value test the hypotheses when the level of significance is a = 0.10

The t test for the average for alpha = 0.10 is given below:

t test for rejoice (alpha = 0.10) Here also we get the p-value = 0.0833

And we have alpha = 0.10

Here, p-value < alpha value

Therefore, we reject the null hypothesis that the average of the weekly sales for Rejoice is \$450.

g) Briefly explain how and when we can use an interval estimate when testing hypotheses.

If the test statistic value in the testing hypothesis is lies between the lower limit and upper limit of the given confidence interval, then we do not reject the null hypothesis that the average of the weekly sales for Rejoice is \$450 and if the test statistic value is out of this confidence interval then we reject the null hypothesis that the average of the weekly sales for Rejoice is \$450.

The scatter plot for the total costs and sales for the Rejoice Chocolates is given as below:

For this scatter plot y represents the total costs and x represents the sales for the rejoice chocolates. The covariance for the total cost and sales is given as below: The correlation coefficient for the total cost and sales is given as below: h)   Write down the two forms of the Population Regression function you would assume here. Briefly explain how we interpret the conditional mean E(Y | X) and the error term (e).

The two forms of the population regression function is written as below:

Y = a + b*X

Where Y is dependent variable, X is independent variable, a is the y-intercept and b is the slope of the regression line.

In another form of the population regression function is given as below:

Total cost = a + b*Sales

We interpret the conditional mean E(Y|X) when we already given the mean of the x values or values of independent variable. The error term is nothing but the difference between the predicted value and the actual value.

i)  Estimate the sample regression function. Write down your estimated model and briefly explain what the estimated intercept and estimated slope are telling us about the relationship between the Total Costs and Sales for Rejoice chocolates.

Here we have to estimate the sample regression function. For this regression model, we take the dependent variable y as the total cost and independent variable x as the sales of the rejoice chocolates. The regression analysis by using excel is given as below: Here we get the correlation coefficient as the 0.9723, this indicate that there is high association between the dependent variable total cost and independent variable sales of the rejoice chocolates. There is high linear relationship found between the dependent variable total cost and independent variable sales of the rejoice chocolates. The ANOVA table for this regression model is given as below: The coefficients for the regression equation are given in the following table: The regression equation is given as below:

Y = 51.7669 + 1.0014*X

Total cost = 51.7669 + 1.0014*sales

j)   Using the F statistic, the R-squared value and the p-value for the estimated slope briefly discuss whether this estimated model does or does not show that there is a significant relationship between Total Costs and Sales for Rejoice chocolates.

(With a sample of n = 52 you can assume that the critical values for the t statistic are the same as the critical values for a z statistic.)

Here the F statistic value is given as 865.47 and p-value is given as 0.00. The value of coefficient of determination or R squared is given as 0.9454, this means, about 94.54% of the variation in the dependent variable total cost is explained by the independent variable sales of rejoice chocolates for this regression model. For this regression model, the p-value is given as 0.00 which is less than the level of significance or alpha value 0.05, therefore we reject the null hypothesis that the linear relationship between the dependent variable total cost and independent variable sales of rejoice chocolates is significant.

k)  Test the following hypotheses concerning the slope

H0 : b1 = 0.8   and   H1 : b1 > 0.8

The complete test procedure is given below:

Null hypothesis: H0 : b1 = 0.8

Alternative hypothesis: H1 : b1 > 0.8

Level of significance = alpha = 0.05

Degrees of freedom = n – 2 = 52 – 2 = 50

Critical value = 2.008559072

Test statistic formula is given as below:

t = b1 / SE

where SE is the standard error and formula for standard error is given as bleow:

SE = sb1 = sqrt [ Σ(yi - Å·i)2 / (n - 2) ] / sqrt [ Σ(xi - x)2 ]

The standard error is given as SE = 0.1373

Test statistic = t = 0.8 / 0.1373 = 5.8267

Critical value = 2.008559072

Test statistic > Critical value

Decision rule: Reject null hypothesis when test statistic value > critical value

Here test statistic value is greater than the critical value, therefore, we reject the null hypothesis that the slope is 0.8.

l)   Using you estimated model forecast the Total Costs when Sales are 200. Comment briefly on how useful this forecast will be.

Briefly explain what we mean by the terms “Prediction Interval” and “Confidence Interval”

Here we are given value of sales = 200. Now for forecasting the total costs we have to use the above regression model which is given as below:

Y = a + b*X

Total cost = a + b*Sales

Y = 51.7669 + 1.0014*X

Total cost = 51.7669 + 1.0014*sales

Now, plug sales = 200 in the above regression equation for estimation or forecasting of total costs.

Total cost = 51.7669 + 1.0014*200 = 252.0469

Total cost = \$252.0469

Prediction interval means, the interval in which the predicted values lies in and the confidence interval means, the interval for which we have exact probability or confidence that the values are lies within this interval.

m)  Using the F statistic, the R-squared value and the scatter diagram which shows the Residuals on the vertical axis and the values of Sales (our X variable) on the horizontal axis briefly discuss whether our estimated model can be seen as a reliable estimate of the relationship between Total Costs and Sales for Rejoice chocolates.

For this regression model, we get the F statistic value as 865.4676 which is very high. The value of coefficient of determination or R squared is given as 0.9454, this means, about 94.54% of the variation in the dependent variable total cost is explained by the independent variable sales of rejoice chocolates for this regression model.

The scatter plot clearly shows the linear relationship exist between the dependent variable total cost and independent variable sales of rejoice chocolates. For this regression model, we reject the null hypothesis that the linear relationship between the dependent variable total cost and independent variable sales of rejoice chocolates is significant.

### Cite This Work

My Assignment Help. (2015). Statistical Inference And Regression Analysis. Retrieved from https://myassignmenthelp.com/free-samples/statistical-inference-and-regression-analysis.

"Statistical Inference And Regression Analysis." My Assignment Help, 2015, https://myassignmenthelp.com/free-samples/statistical-inference-and-regression-analysis.

My Assignment Help (2015) Statistical Inference And Regression Analysis [Online]. Available from: https://myassignmenthelp.com/free-samples/statistical-inference-and-regression-analysis
[Accessed 11 December 2019].

My Assignment Help. 'Statistical Inference And Regression Analysis' (My Assignment Help, 2015) <https://myassignmenthelp.com/free-samples/statistical-inference-and-regression-analysis> accessed 11 December 2019.

My Assignment Help. Statistical Inference And Regression Analysis [Internet]. My Assignment Help. 2015 [cited 11 December 2019]. Available from: https://myassignmenthelp.com/free-samples/statistical-inference-and-regression-analysis.

### Latest Statistics Samples

#### QMTH104 Quantitative Methods

• Course Code: QMTH 104
• University: Kent Institute Australia
• Country: Australia

Answer: Introduction This report emphasizes on the analysis of the expenditure patterns of international students in Australia. For this purpose, there is a need to collect the relevant information from the international students visited or residing in Australia to pursue their studies. The target population consists of the international students residing in Australia in order to gather information regarding their expenditure patterns. The ma...

Read More #### WACS100-Air Quality On Residents Living Near Tunnel Emission Stacks

Answer: Introduction  Air pollution from vehicle exhausts is among the main contributors to pulmonary and cardiovascular diseases globally. Human contact with vehicle exhausts occurs to pedestrians walking along the roads as well as the drivers and commuters in the vehicles on the road. This contact is more for people who live or work in areas that are continuously exposed to vehicle exhausts. These areas include residential and work pla...

Read More #### BUS501 Business Analytics And Statistics

Answer: Introduction Company sales is one of the key performances that shows that the business is either doing well or in some verge to collapse. The CEO of Honeybee Fruit is a concerned person and would want to understand how the company is performing. He is particularly interested in knowing which of the products are doing well and which ones are not doing well in the market. With this in mind, this study therefore sought to analyse the per...

Read More #### BUS708 Statistics And Data Analysis 2

Answer: Introduction a) Due to growth in city size and underlying population, the public transport infrastructure requires maintenance and capital investments so as to provide mobility options to the people that are efficient yet affordable. One of the ways in which the efficiency factor coupled with assessability is improved is through alternation of timings and overhauling of routes so as to ensure wider coverage to a larger number of peopl...

Read More Next ### Save Time & improve Grades

Just share your requirements and get customized solutions on time. Orders

Overall Rating

Experts

### Our Amazing Features #### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline. #### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers. #### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. #### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level. #### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts      5/5

529 Order Completed

95% Response Time

### Ivan Blank

#### Wellington, New Zealand      5/5

184 Order Completed

96% Response Time

### Arapera Billing

#### Wellington, New Zealand      5/5

2830 Order Completed

97% Response Time

### Leroy Bicknell

#### London, United Kingdom      5/5

798 Order Completed

97% Response Time

### FREE Tools #### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us. #### Essay Typer

Get different kinds of essays typed in minutes with clicks. #### GPA Calculator #### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula. #### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

thanks for giving me quality work.................................................. #### User Id: 356016 - 11 Dec 2019

Australia     I must say that I am very impressed with the assistance here. I received a verrrrrry high grade which I am very pleased. The expert followed instructions exactly to the specifications of the Professor. Very well done. I am very impressed! #### User Id: 80507 - 11 Dec 2019

Australia     They did an awesome job. I only had to go through and make minor, but that was no problem considering the quality of content I received. #### User Id: 349107 - 11 Dec 2019

Australia     This was just what I needed!! paper turned out great! I would recommend to anyone who is in a bind and needs a quick fix to catch on work!!! #### User Id: 355040 - 11 Dec 2019

Australia      