# Business Analytics statistics

posted by .

I don't under stand ho to get the answer to this excel question can anyone help?
and email me back
skylerbloo at netscape . net

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

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.)

• Business Analytics statistics -

Sorry here is the only information I have to go on.

Final Project Spreadsheet -- Master Worksheet

Sales and Cost Data
Quarter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Total
Product Line (K Units)
Alpha 5 5 8 10 11 11 12 11 12 9 12 11 11 11 13 12 13 14 15 12 218
Beta 11 14 3 12 12 12 8 10 12 11 11 9 9 8 9 9 13 9 10 11 203
Gamma 4 8 7 4 4 6 9 3 5 6 8 3 8 9 3 3 4 5 5 3 107
Total Sales (K Units) 20 27 18 26 27 29 29 24 29 26 31 23 28 28 25 24 30 28 30 26 528

Total Sales \$M 2.00 2.70 1.80 2.60 2.70 2.90 2.90 2.40 2.90 2.60 3.10 2.30 2.80 2.80 2.50 2.40 3.00 2.80 3.00 2.60 52.8

Total Costs \$M 1.00 1.35 0.90 1.30 1.35 1.45 1.45 1.20 1.45 1.30 1.55 1.15 1.40 1.40 1.13 1.08 1.35 1.26 1.35 1.17 25.585

Quality Data
Mean 70
Standard Deviation 2
Cuttoff 65

Training Data
Mean Hours 40
Standard Deviation 5
Employees in Sample 40

• Business Analytics statistics -

Since we Jiskha tutors have no connection with any school, we have no access to "Final Project Spreadsheet -- Master Worksheet."

I don't think any of us has a background in business analytical statistics.

Please note that we do not email answers.

• Business Analytics statistics -

Hi
Is there a way for me to post the master worksheet? For you

• Business Analytics statistics -

Final Project Spreadsheet -- Master Worksheet

Sales and Cost Data
Quarter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Total
Product Line (K Units)
Alpha 5 5 8 10 11 11 12 11 12 9 12 11 11 11 13 12 13 14 15 12 218
Beta 11 14 3 12 12 12 8 10 12 11 11 9 9 8 9 9 13 9 10 11 203
Gamma 4 8 7 4 4 6 9 3 5 6 8 3 8 9 3 3 4 5 5 3 107
Total Sales (K Units) 20 27 18 26 27 29 29 24 29 26 31 23 28 28 25 24 30 28 30 26 528

Total Sales \$M 2.00 2.70 1.80 2.60 2.70 2.90 2.90 2.40 2.90 2.60 3.10 2.30 2.80 2.80 2.50 2.40 3.00 2.80 3.00 2.60 52.8

Total Costs \$M 1.00 1.35 0.90 1.30 1.35 1.45 1.45 1.20 1.45 1.30 1.55 1.15 1.40 1.40 1.13 1.08 1.35 1.26 1.35 1.17 25.585

Quality Data
Mean 70
Standard Deviation 2
Cuttoff 65

Training Data
Mean Hours 40
Standard Deviation 5
Employees in Sample 40

## Similar Questions

1. ### Statistics

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 …

3. ### HCA220

I answered several question for an assignment and I need help to understand how I got it wrong. The assignment dwelt medical terms. The following three were marked wrong. Please help! Use the word bank below to build the medical word …
4. ### statistics

Roger Amster teaches an English course in which 40 students are enrolled. After yesterdays class, roger questioned the 5 students who always sit in the back of the classroom. Three of the 5 said “yes” when asked if they would like …
5. ### BIS155 - Final Exam

Fact Pattern Question 2: You own your own small party supply and rental business. You maintain an Excel list of potential customers and clients who have rented or purchased from you in the past two years. the list includes both physical …
6. ### Geometry (math)

Suppose line p is perpendicular to line s and line q is perpendicular to line s. are p and q parallel under all circumstances?
7. ### business analytics

Ill be concise:60% of people in survey had income greater than 25k, 40% under 25k. Further, same survey, 70% have exactly 2 cars, while 30% have a different number than 2. The probability that the residents own 2 cars IF income is …
8. ### Geometry

Hi, so i reallllyy need help, i have an assignment that i have to complete, but the thing is theres a file and this site doesn't allow links, so does anyone have email to help me if you can help i will greatly appreciate it i'll email …
9. ### Statistics

In a shipment of 21 parts, four of the parts are defective. If three parts are selected at random without replacement, find the probability that : a.) All three parts selected are defective. 4/21*3/20*2/19=.003 b.) None of the tree …
10. ### Algebra

This is a two part question, make sure you answer both parts: In the following subtraction problem the letters A, B and C stand for three different digits ( There are not any other operations involved in this problem). What digits …

More Similar Questions