Reference no: EM131010091
Description:
You are consultants working with local bakery chain. In order to better calibrate their models to predict sales, your supervisor has asked your group to develop a model to estimate the monthly sales of their bakeries based on survey data to create a 100 point scale of the quality of the local baked goods. A higher score indicates that the quality of the baked goods is higher.
You will use descriptive statistics, inferential statisticsand your knowledge of simple linear regression to complete this task.
Monthly salesdata for 25 locations (Dependent Variable)and number of competitors in the surrounding area(Independent Variable) are given in the Excel file: Data.xlsx.
Here is a table describing the variables in the data set:
Required:
A. Calculate the descriptive statistics from the data and display in a table. Be sure to comment on the central tendency,variability (both absolute and relative)as well as shape for each variable.
B. Draw a graph that displays the distribution of the quality of baked goods amongst the 25 stores.
C. Create a box-and-whisker plot for the distribution of monthly sales and describe the shape. Is there evidence of outliers in the data?
D. What is the likelihood that sales are more than $60,000when the quality is below a score of 60?Is salesgreater than $60,000 statistically independent of the event that the quality of baked goods is below a score of 60? Use a Contingency Table.
E. Estimate the 95% confidence interval for the population mean monthly sales.
F. Your supervisor recently stated that it is obvious that the mean monthly sales is greater than$45,000,which was the average monthly sales the previous month. Test his claim at the 10% level of significance.
G. Run a simple linear regression using the data and show the output from Excel.
H. Is the coefficient estimate for the slope statistically different than zero at the 5% level of significance? Set-up the correct hypothesis test using the results found in the table in Part (G) using both the critical value and p-value approach. Interpret the coefficient estimate of the slope.
I. Is the sign of the coefficient what that you were expecting? Discuss.
J. Interpret the value of the R2.
Attachment:- data7-1.xlsx
|
What is the payback period of this investment
: You are considering making a movie. The movie is expected to cost $100 million upfront and takes a year to make. After that, it is expected to make $80 million in the first year it is released and $6 million for the following 20 years. Your cost of c..
|
|
Subsequent retirement payments
: Assume that your father is now 50 years old, plans to retire in 10 years, and expects to live for 25 years after he retires - that is, until age 85. He wants his first retirement payment to have the same purchasing power at the time he retires as $35..
|
|
Problem regarding the business in making some decision
: What are three types of gaps that exist, indicating that research may be needed to assist a business in making some decision?
|
|
Problem regarding the story of failure
: Read chapter 6 and the case study, A Story of Failure: Golden Gate Airlines on page 129 and answer the following questions:
|
|
Draw a graph that displays the distribution
: Calculate the descriptive statistics from the data and display in a table. Be sure to comment on the central tendency,variability (both absolute and relative)as well as shape for each variable - Draw a graph that displays the distribution of the qu..
|
|
Divergences between daoist and pre-socratic ideas
: Look for convergences and divergences between Daoist and pre-Socratic ideas with reference to Heidegger's phenomenology and Derrida's deconstruction
|
|
Problem rageding sprocket manufacturing
: The manager of this production firm is faced with a potential problem: shortages in the supply of a vital gear sprocket. He is considering the development of an in-house capability to make the sprockets, knowing that the firm needs 35,000 such spr..
|
|
The stock of flop industries is trading
: The stock of flop industries is trading at $43. you feel the stock price will decline, so you short 700 shares at an initial margin of 70 percent. if the maintenance margin is 40 percent, at what share price will you receive a margin call?
|
|
What is monthly amount they will receive during retirement
: Kwame and Omarosa, both age 40, have $80,000 of combined retirement assets. They both expect to retire at the age of 65 with a life expectancy of 100 years old. They expect to earn 10% on the assets within their retirement accounts before retirement ..
|