Share
Explore BrainMass

Statistics - Excel Data Analysis

1. Calculate the Mean, Median, and Mode of this sample. Show Calculations: Use any calculation method desired

20,21,25, 28, 26, 30, 24, 32, 31, 27, 29, 32,39,40.

1.a. Mean:___________
1.b. Median:__________
1.c. Mode:___________

2. Following are the weekly amounts of payments made by the federal government: Calculate the Standard Deviation of this sample. $130, $139, $136, $130, $136, $136, $145, $155. Use Full function Excel if you like.

3. Recent medical research indicates that skin cancer patients who receive a new medication live longer than those who do not. The average length of life prior to the development of this medication was 18 months. That is the claim is that the patients live 18 months or less without the new treatment. Can we conclude that the patients who receive the new medication live longer than i.e. greater than 18 months. Show all steps for the test of hypothesis using significant level 0.05.

Here is the complete set of data available for the test of hypothesis.

Patient number Length of life after medication/months
1 17
2 17.8
3 19
4 17
5 18.5
6 19.5
7 20
8 19
9 17
10 18
11 22
12 22.5

4. Show the 5 steps to this ANOVA data for 4 different IC chips in an electronic assembly plant. Use a significant level of 0.05. Show the 5 steps of the hypothesis test. If you have data analysis show me the ANOVA table, if you do not have data analysis, the F value is F=5.27, show me the additional steps ie all 5 steps of the hypothesis test.

Treatment 1 Treatment 2 Treatment 3 Treatment 4
3 19 10 21
4 15 12 25
12 14 15 12
6 10 14 13
12 16 19
10 10
20

5. XEL Communications wants to know if there is correlation between two test sets. Provide the Coefficient of Correlation for the following data. Readings are in decibels.

Unit number Test set # 1 Test set #2
1 3.46 3.47
2 3.55 3.45
3 3.47 3.40
4 3.0 3.9
5 4.1 3.9
6 3.55 3.55
7 4.0 3.88
8 3.8 3.5
9 3.0 3.0
10 3.8 4.1

6. Use a five period moving average to determine the moving average of this data beginning with May and subsequent months.

Month Sales Moving average
Jan 12958
Feb 12731
Mar 13901 Fill May here
April 13232
May 13266
June 13433
July 13324
Aug 13244
Sept 13523
Oct 13634
Nov 13677
Dec 14100
Jan 14001
7. A discount store issues its own credit card. The credit manager believes that the mean monthly unpaid balance is $400 or less. The level of significance is set at .05. A random check of 172 unpaid balances revealed the sample mean is $407.00 and the standard deviation is $38.00. The manager wants to test if the mean is greater than $400.00. Show the 5 step hypothesis test the manager should use to make her decision.

8 Your company has been building a long-term relationship with one of its suppliers in the spirit of Total Quality Management. To validate the supplier's claim that no more than 1.0% of the delivered product is defective, you take a sample of 25 products and find that only 1 of the 25 is defective. Should you believe the supplier's claim? Test the hypothesis that the defectives are greater than 1.0%. Show the 5 steps of the hypothesis using a significant level of 0.05.

Attachments

Solution Summary

Solutions to the posted problems given with step by step explanation and Excel images so that student could easily understand. The Screen shots of excel at each step of solution are included to facilitate the student to understand the procedure of using Excel for Statistics problems.

$2.19