# Sample Distribution for Work Processing Formulas

I need to word-process the formulas using the Equation function in MS Word(not using Excel).

Time lost due to employee absenteeism is an important problem for many companies. The human resources department of Western Electronics has studied the distribution of time lost due to absenteeism by individual employees. During a one-year period, the department found a mean of 21 days and a standard deviation of 10 days based on data for all the employees.

a) If you pick an employee at random, what is the probability that the number of absences for this one employee would exceed 25 days?

b) If many samples of 36 employees each are taken and sample means computed, a distribution of sample means would result. What would be the mean, standard deviation and shape of the distribution of sample means for samples of size 36?

c) A group of 36 employees is selected at random to participate in a program that allows a flexible work schedule, which the human resources department hopes will decrease the employee absenteeism in the future. What is the probability that the mean for the sample of 36 employees randomly selected for the study would exceed 25 days?

© BrainMass Inc. brainmass.com October 25, 2018, 1:15 am ad1c9bdddfhttps://brainmass.com/statistics/sampling/sample-distribution-257478

#### Solution Preview

Time lost due to employee absenteeism is an important problem for many companies. The human resources department of Western Electronics has studied the distribution of time lost due to absenteeism by individual employees. During a one-year period, the department found a mean of 21 days and a standard deviation of 10 days based on data for all the employees.

a) If you pick an employee at random, what is the probability that the number of absences for this one employee ...

#### Solution Summary

The solution examines sample distribution for work processing formulas using the equation function.

Distribution of Temperatures - Descriptive and General Statistics

Problem 1: Using Symbols

Word-process the symbol for population standard deviation (sigma) in the space below:

Using Subscripts

Word-process the symbol for population standard deviation with subscript x (sigma subscript x) in the space below:

Using Equations

Word-process the following five equations:

k= N/n

z= (x ̅-μ)/(σ/√n)

z=(x ̅-μ)/(σ/√n √((N-n)/(N-1)))

p ̂=x/n

z=(p ̂-p)/√((p∙q)/n)

Using Drawing Tool to Create Diagrams

Suppose in a large department store, the average number of shoppers is 448, with a standard deviation of 21 shoppers. We are interested in the probability that a random sample of 49 different shoppers will yield a sample mean between 441 and 446 shoppers. Create and attach a normal curve to this document with the following elements: the normal curve, a label of the average number of shoppers, and labels for the sample means of 441 and 446 shoppers. Include all the appropriate symbols.

Problem 2: Descriptive Statistics

The monthly average low temperatures* during different months of year at Manchester, NH are given below:

January February March April May June

5 8 18 29 40 50

July August September October November December

55 53 44 32 24 12

Word-process your solutions and answers below. Copy and paste your Excel work under the appropriate question below. Expand the space as necessary.

a) Find the mean yearly low temperature based on the monthly averages by applying the formulas (without using computer software).

b) Find the standard deviation of the monthly low temperatures by applying the formulas (without using computer software).

c) If the above data was a sample, what would be the sample standard deviation? Compute by applying the formulas (without using computer software).

d) Copy and paste the data from this document to Excel. Use functions in Excel to compute the mean, population standard deviation and sample standard deviation. Copy and paste your spreadsheet work into this Word document.

e) Create a histogram using MS Excel. Comment on the distribution of monthly low temperatures. Copy and paste your spreadsheet work into this Word document. Hint: use 9, 19, 29, 39, 49 for the bins.

View Full Posting Details