BAD_2323_Module 2_Hwk-1 (2)

xls

School

Itawamba Community College *

*We aren’t endorsed by this school

Course

2323

Subject

Accounting

Date

Feb 20, 2024

Type

xls

Pages

6

Uploaded by BarristerElementSparrow34

Report
BAD 2323 Module 2 Hwk 1. Use the following data to calculate the mean and the median: X 10 10 20 12 12 16 17 17 16 20 Mean: 15 Median: 16 2. Use the following data to calculate the following percentiles: 20th. 20 25th. 20 50th. 25 65th. 27 75th. 28 27 15 25 20 20 25 15 25 30 27 34 28 28 30 25 34 3. Using the following data, calculate: Mean Median Mode 53 53 55 53 70 53 58 55 64 57 57 57 53 58 69 64 57 68 68 69 53 70 Mean: 59.7Median: 57Mode: 53 4. Using the following Sample data, calculate: Range Inter-quartile Range
Variance Standard Deviation 10 Variance: Standard deviation: IQR: 12 12.8 3.57 7 16 17 20 5. Calculate the Z score for each of the following numbers. 10 -1.4 12 -0.84 16 0.28 17 0.56 20 1.4 6. If a sample has a mean of 500, and standard deviation of 100, what is the Z score for x of 520? 0.2 7. Mean = 30. Standard Deviation = 5 Using Chebyshev's Theorem, calculate the percent of data lying between: a. 15 to 45 89% b. 22 to 38 60.94% 8. Using the Sample data below, calculate: Mode, Median, Mean, Variance, Standard Deviation Range, Coefficient of Variation (CV = s / mean), and Pearson's Skewness Coefficient. Skewness = 3*(mean - median) / s x 1 15 mean: 25.5 2 20 Median: 26 3 25 mode: 25 4 25 Variance:24.59 5 27 SD: 4.95 6 28 Range: 19 7 30 CoV: .19 8 34 Pearson: -.3 Sum 204 9. Using the data below, calculate: Q1, Q3, Step, Upper Fence, Lower Fence,
Outliers if any. x 1 15 Q1: 20 2 20 Q3: 28 3 25 step: 9.75 4 25 Upper: 38.75 5 27 Lower: 12.75 6 28 Outliers: 34 7 30 8 34 Sum 204 10. Using the following Sample data: Calculate Covariance and Coefficient of Correlation. x y 4 50 6 50 11 40 3 60 16 30 sum 40 230 11. Using the following Sample data: Calculate Covariance and Coefficient of Correlation. x y 6 6 Covariance: 26.5 11 9 CoC: .69 15 6 21 17 27 12 80 50 12. Using the following data, calculate the weighted average. 6 packages weigh 3.2 pounds 3 packages weigh 2 pounds 2 packages weigh 2.5 pounds 8 packages weigh 5 pounds AVG: 3.69 13. Using the following frequency distribution, calculate the mean, variance, and standard deviation. Class m f 3-7 5 4 Mean: 13
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
8-12 10 7 Variance: 25 13-17 15 9 SD: 5 18-22 20 5 Sum 25 14. Using the following frequency distribution, calculate the mean, variance and standard deviation. Class m f 0-4 2 74 Mean: 10.74 5-9 7 192 Variance: 25.68 10-14 12 280 SD: 5.07 15-19 17 105 20-24 22 23 25-29 27 6 680 15. A drug company is trying to evaluate the effectiveness of its cough medicine in coughs per hour (CpH)…# coughs / # hours. Five brands are being tested with each brand being evaluated on the basis of 100 coughs (numerator). Since the numerator is the same, calculate the harmonic mean. Brand CpH 1 30 Hmean: 49.02 2 38 3 60 4 70 5 85 16. Three secretaries are evaluated according to errors per minute (errors/minutes). Each secretary keeps typing until he/she makes five errors. The errors and minutes are given below: Sec. Errors Minutes 1 5 2 Im not sure what is being asked. 2 5 5 3 5 1 17. Calculate the Weighted Avg if Daily tests are 10%, Weekly tests count 30%, and Final Exam counts 60% Test X W Daily 85 0.1 WMean: 90.7 Weekly 78 0.3 Final 98 0.6
Sum 1 18. Calculate the average increase in Salary using the Geometric Mean. Year Salary 0 20000 Gmean: 13% 1 21500 2 24000 3 28500 4 29000 5 32000 19. Using the following frequency distribution, calculate the mode, median, mean, variance, standard deviation, Skewness. f 10 up to 15 3 12.5 Mean: 21.63 15 20 6 17.5 Mode: 20-25 20 25 8 22.5 Median: 16.875 25 30 4 27.5 Variance: 10.8 30 35 2 32.5 SD: 3.29 23 Skewness: .17 20. Using the following frequency distribution, calculate the mode, median, mean, variance, standard deviation, Skewness. f 10 up to 20 5 Mean: 32.58 20 30 8 Mode: 30-40 30 40 12 Median: 23.33 40 50 6 Variance: 102.49 50 60 2 SD: 10.12 33 Skewness: -0.05 21. Using the following frequency distribution, calculate the mode, median, mean, variance, standard deviation, Skewness. f 20 up to 30 8 Mean: 41.67 30 40 10 Mode: 40-50 40 50 18 Median: 32.8 50 60 7 Variance: 103.61 S f= S f=
60 70 2 SD: 10.18 45 Skewness: -0.18 S f=
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help