posted by .

The assignment is in three parts:

1. An analytic section that you will submit as an Excel spread sheet
2. A PowerPoint presentation of 3 to 5 slides.
3. A narrative section that you will submit as a two to three page Word document
First, read the business case and identify the business decisions that need to be made. Then, using the case datasheet, perform a statistical analysis of the data and obtain the required statistics. Submit your analysis as an Excel spreadsheet. Your spreadsheet will contain numerical data. You will then submit a PowerPoint file to showcase graphical information. Finally, in a narrative of about two to three pages, describe the business situation and the decisions that the business must make. Explain, based on your findings, a recommended course of action for the business. Refer to the statistics you calculated and the graphs you created in the spreadsheet. Submit your narrative as a Word document.

The ThermoStar Case

ThermoStar has been producing residential thermostats for over 50 years.

Looking over the past 20 quarters (5 years) of the different product lines, the general manager has been trying to get a handle on sales, costs, and production, and has asked for your help.

Answer the following using Excel and refer to your datasheet.

1. Calculate the descriptive statistics (summary statistics) for total sales (in K units), and report the mean, median, and standard deviation.
2. Using the unit data by product line, compile a breakdown of sales by product. Also, show the expected sales by product for 100,000 total units.
3. ThermoStar tests thermostats so they are calibrated with a mean of 70 degrees, with an associated standard deviation of 2 degrees. Given this mean and standard deviation what percentage of thermostats will test below the inspector’s cutoff value and thus need to be recalibrated? (See the data sheet for the cutoff and assume that the test results are normally distributed.)
4. A sample of 40 employees showed the average time spent in training per year to be 40 hours, with the associated standard deviation as noted in the datasheet. Construct a 95 percent confidence interval for the training program.
5. Do a simple regression for the total costs. Report the regression equation, as well as the R2 and t-statistic. Is this model suitable for business decision making? Explain why. (Hint: copy and paste special, transpose the data into columns, then run the regression tool.)

  • Statistics -

    For the manufacturing plant discussed in Exercise 8.10, the union president and the human resources director jointly select a simple random sample of 36 employees to engage in a discussion with regard to the company’s work rules and overtime policies. What is the probability that the average number of overtime hours last year for members of this sample would have been less than 65.0 hours? Between 55.0 and 65.0 hours?

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. scholarship thing

    for the scholarship, it says we can submit additional work that would give evidence to why we would excel in an honors program. i would really like to submit some photos i took but i'm not sure that would help me, especially when i …
  2. Business Analytics statistics

    I don't under stand ho to get the answer to this excel question can anyone help?
  3. computers

    The President of the Company has asked you to replace the computers in every department. The researched information must be presented in this format: A memo to the president stating the need to replace the computers. An Excel spreadsheet …
  4. science

    4. Assignment: Photosynthesis and Cellular Respiration Powerpoint Energy acquisition is essential for all life. Whether the organism is classified as plant or animal, single-celled or multicellular, the exchange of energy and the formation …
  5. Business

    Research the Goldman Sachs website. Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables are …
  6. health care

    This week, you will create a PowerPoint presentation to help you prepare for your Final Paper. Submit a 10-slide (excluding title and reference slides) PowerPoint presentation that provides an overview of your research thus far for …
  7. Health Information Technology

    I have to create an acute care record and am looking for blank medical templates. The list below is what I need Face Sheet; Registration Form; Doctors Order Form w/orders to include admission, treatment plan, medications; nurses note …
  8. Project management

    Build a PowerPoint® presentation that will address each of the Project Management Areas of Knowledge, the process groups that use these areas of knowledge, and how the process groups interact with the knowledge area processes. Use …
  9. criminal justice

    the two basic parts of crime report are the: a. face sheet and the narrative section b. narrative section and fact sheet c. statistical section and fill in the blank section d. information section and the fact sheet. is it B
  10. Civics Presentation (Help!)

    I am creating a poster presentation for my Civics class, and I was wondering if this was a good layout for a poster about the Libertarian Party. Layout: 1. Section 1: Intro (explaining what is the Libertarian Party) 2. Section 2: Background …

More Similar Questions