This assignment has an Excel® dataset spreadsheet attached. You will be required to only do one of the three datasets. Resource: Microsoft Excel®, Statistics Concepts and Descriptive Measures Data SetDownload the Statistics Concepts and Descriptive Measures Data Set. Choose one of the following datasets to complete this assignment:Consumer FoodFinancialHospitalAnswer each of the following in a total of 90 words:For each column, identify whether the data is qualitative or quantitative.Identify the level of measurement for the data in each column.For each column containing quantitative data:Evaluate the mean and medianInterpret the mean and median in plain non-technical termsUse the Excel =AVERAGE function to find the meanUse the Excel =MEDIAN function to find the medianFor each column containing quantitative data:Evaluate the standard deviation and rangeInterpret the standard deviation and range in plain non-technical termsUse the Excel =STDEV.S function to find the standard deviationFor range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel's =MIN function Click the Assignment Files tab to submit your assignment.

Purpose of AssignmentThe purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps Resources: Yahoo Finance Select a Fortune 500 Company from one of the following industries:PharmaceuticalEnergyRetailAutomotiveComputer HardwareManufacturingMiningAccess Yahoo Finance and enter the company name. Review the financial information and statistics provided for the stock you selected and answer the following:What is the ticker symbol of the company you chose?What is the Current Stock Price?What is the Market Cap for the stock you chose?What is the Price to Earnings Ratio?What is the Dividend and Yield?What is the Enterprise Value?What is the Beta?Was there a Stock Split, and if so, when?What was the closing stock price for the last 5 days?What was the 52 Week High for this stock?What is the Book Value per Share?What type of rating are analysts recommending (i.e. buy, hold, etc.)?What is the target price analysts are predicting for this stock?What is the analyst's average revenue estimate for next year?What are some of the significant news items and press releases made by the company over the last year? Explain in 700 words why you would or would not recommend investing in this stock. Describe the relationship between the value of the stock and the price to earnings ratio. What information does the Market Capitalization (Market Cap) and Beta provide to the investor?

Purpose of Assignment The purpose of this assignment is for students to learn how to make managerial decisions using a case study on Normal Distribution. This case uses concepts from Weeks 1 and 2. It provides students an opportunity to perform sensitivity analysis and make a decision while providing their own rationale. This assignment also shows students that statistics is rarely used by itself. It shows tight integration of statistics with product management. Assignment Steps Resources: Microsoft Excel®, SuperFun Toys Case Study, SuperFun Toys Case Study Data Set Review the SuperFun Toys Case Study and Data Set. Develop a 1,050-word case study analysis including the following: Use the sales forecaster's prediction to describe a normal probability distribution that can be used to approximate the demand distribution.Sketch the distribution and show its mean and standard deviation. Hint: To find the standard deviation, think Empirical Rule covered in Week 1.Compute the probability of a stock-out for the order quantities suggested by members of the management team (i.e. 15,000; 18,000; 24,000; 28,000).Compute the projected profit for the order quantities suggested by the management team under three scenarios: pessimistic in which sales are 10,000 units, most likely case in which sales are 20,000 units, and optimistic in which sales are 30,000 units.One of SuperFun's managers felt the profit potential was so great the order quantity should have a 70% chance of meeting demand and only a 30% chance of any stock- outs. What quantity would be ordered under this policy, and what is the projected profit under the three sales scenarios?