Conduct a hypothesis test on the population mean

Assignment Help Advanced Statistics
Reference no: EM131016547 , Length:

I need a statistics project done.

The project needs to be done in Excel using the appropriate functions and tools. You may use MicrosoftWord to write up the discussions, assumptions, and the limitations (see below for more information).

• Excel is used significantly in business and industry and this project will provide you with an opportunity to hone your Excel skills. Examples on how to create certain types of charts (e.g. scatter, bar, pie) and use formulas (e.g. how to find the mean, normal probabilities, etc.) can be found in Canvas Modules under the appropriate chapters and in the class text. If you have questions on how to do the statistical analysis in Excel then please do not hesitate to contact your instructor prior to the due date.

• Please note that simply typing in your work (calculations) into Excel is not sufficient. You must use appropriate Excel functions (e.g. =AVERAGE) to find the probabilities and other calculations.

• The work needs to be clear and well organized. Points will be deducted for work that is not clear or missing.

• Clearly label each part of the project.

• All the data for the project can be found in the Excel file: Project Data. There are three worksheets in this Excel file. See below for information regarding the data.

Scenario

Maggie has recently opened a coffee shop near a college campus. She likes statistics and has been compiling information regarding favorite customer beverages and total daily sales.

Part 1: Qualitative (Categorical) Data:

Use the information given in the Table 1 worksheet for Part 1. Maggie surveyed 250 customers regarding their favorite beverage at the coffee shop.

• Organize the data by creating a frequency distribution and relative (or percentage) frequency distribution for the favorite beverages.

• Organize the data by creating a bar graph and pie chart. Be sure to include data labels and titles in your charts.

• Discuss the results of these tables and graphs. What are the least and most popular items? This needs to be at least one (1) paragraph in length. Note a paragraph contains at least three complete sentences. Watch your spelling and grammar.

Rubric for Part 1:

Frequency and relative (or percentage) frequency distribution: 6 possible points

Bar graph and pie chart:

Part 2: Quantitative Data

Use the information given in worksheet Table 2 for Part 2. The data is the past 45 days of total daily sales at the coffee shop. A histogram, the sample mean, median, and sample skewness values for this data is provided in the Table 2 worksheet.

• Discuss the results of the histogram and the shape of the data for total daily sales at the coffee shop. This needs to be at least one (1) paragraph in length. Note a paragraph contains at least three complete sentences. Watch your spelling and grammar.

• Conduct a hypothesis test on the population mean for total daily sales to see whether the population mean is $740 using critical value, p-value, and confidence interval approaches. You need to provide the following for the hypothesis test: o Null and alternative hypothesis statements o Test statistic o Critical values o P-value o Confidence intervals o Clearly explain whether one should reject or not reject the null hypothesis and why using the critical value, p-value, and confidence interval approaches at both 0.01 and 0.05 levels of significance.

• What assumptions did you make about the process when conducting your hypothesis test on the population mean for total daily sales. This needs to be at least one (1) paragraph in length. Note a paragraph contains at least three complete sentences. Watch your spelling and grammar.

Part 3: Normal Probability:

Maggie believes that daily sales are normally distributed with a mean of $750 and a standard deviation of $60. Determine the following and show your work using the appropriate Excel functions.

• Find the probability that daily sales are less than $800.

• Find the probability that daily sales are greater than $850.

• Find the probability that daily sales are between $715 and $785.

• Find the probability that daily sales are less than $650 or greater than $825.

• Find the amount ($) where the probability is 55% that sales are less than this value.

• Find the amount ($) where the probability is 7.5% that sales are greater than this value.

Part 4: Scatter Diagram, Covariance, Correlation, and Regression

Maggie has been offering monthly promotions at her business. Table 3 worksheet shows the number of promotions and total monthly sales for the past 15 months. Determine the following:

• Create a scatter diagram. Be sure to include axis titles on your graph.

• Calculate the sample covariance and sample correlation coefficient.

• Discuss the results of the correlation coefficient and scatter diagram. Is there a possible relationship between the number of promotions and sales? Explain and use your results to back up your statements. This needs to be at least one (1) paragraph in length. Note

A paragraph contains at least three complete sentences. Watch your spelling and grammar.

• What are the limitations of the correlation coefficient result? Explain. Watch your spelling and grammar.

• Run a linear regression using Excel's Data Analysis regression tool. Construct the linear regression equation and determine the predicted monthly sales value if the number of promotions per month is 6. Is the regression model significant? Clearly explain your reasoning using the regression results.

Attachment:- Project Data-stats.xlsx

Reference no: EM131016547

Questions Cloud

Decrease the firm annual dividend : Horseshoe Stables is losing significant market share and thus its managers have decided to decrease the firm's annual dividend. The last annual dividend was $0.90 a share but all future dividends will be decreased by 10 percent annually. What is a..
What is the effective rate : Work out several exercises to compute the EAR and APR on a loan. Be sure to use the Excel functions EFFECT and NOMINAL. What is the effective rate of a 4% APR loan compounded quarterly? What is the nominal rate of a 5.62 effective rate compounded ..
Discuss the role of commitment within relativistic thinking : Analyze how dualistic and relativistic thinking contribute to our vocational choices and discuss the role of commitment within relativistic thinking.
The total contribution margin for the month : The total contribution margin for the month under variable costing is:
Conduct a hypothesis test on the population mean : Discuss the results of the correlation coefficient and scatter diagram. Conduct a hypothesis test on the population mean for total daily sales to see whether the population mean is $740 using critical value, p-value, and confidence interval approac..
What are the elements needed to create a strategic plan : What are the elements needed to create a strategic plan, and what are the benefits of each? Explain why it's important for an organization to examine itself before creating a strategic plan
A manufacturing company that produces a single product : What is the net operating income for the month under absorption costing?
Advantages of the low task standard : In your own words clearly and completely explain the advantages and the disadvantages of the Low Task Standard and the High Task Standard methods of rating employee work
What the first bit of advice : 1. What's the first bit of advice you'd give to someone who's thinking of starting their own business?

Reviews

Write a Review

 

Advanced Statistics Questions & Answers

  Find the steady-state probability of each given state

Find the steady-state probability of each state. Find the time-average rate at which customers leave node 1. Find the time-average rate at which a given customer cycles through the system.

  The numbers at below represent a sample of 50 data pairs in

the numbers at below represent a sample of 50 data pairs in protein residue analysis. in this case a presence of an

  What is the probability that the device will fail

What is the probability that the device will fail during the second year of operation and draw a fault tree for the failure of the system to deliver any coolant to the primary system in the event of an accident.

  Determining the exchange rates of intel

Intel has the choice of borrowing dollars at 9.5% or yen at 7% for one year. The current exchange rate is ?152=$1. At what end of year exchange rate would the yen costs of these two loans be equal?

  Determining pert and cpm

Assume you are going to manage a large construction project involving many subcontractors. Why use PERT or CPM to plan the project rather than just logically scheduling the subcontractors?

  Classified balance sheet and income statement

Doug Maltbee formed a lawn service business as a summer job. To start the business on May 1, he deposited $1,000 in a new bank account in the name of the proprietorship.

  Individual project most businesses can benefit from

individual project most businesses can benefit from statistical process controls to ensure consistency in product or

  Computing desired probability values

Calculate the probability that the project will be completed in 38 weeks. Calculate the probability that the project will be completed in 42 weeks.

  What do you recommend to johnson construction company

The company wants to minimize the total length of wire used, which would minimize the company's cost - what do you recommend to Johnson Construction Company?

  Worker satisfaction-compensation strategy

How does one's ability, motivation and opportunities distinguish themselves as it relates to worker satisfaction? Explain the value of a strategic compensation strategy?

  Making t-ledger and a journal

I just need help with setting this accounting question up on a t-ledger and a journal it has to be on an excel format as well. I am just confused on how to set it up

  Managerial and financial accounting

What type of information does managerial accounting provide? What type of information does financial accounting provide?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd