A1 Business and Technical College Statistics Excel Work File download the files down below and follow all the steps please thank you >>>>>>>>>>>>> A. Do

A1 Business and Technical College Statistics Excel Work File download the files down below and

follow all the steps please

thank you

>>>>>>>>>>>>> A. Documentation [1]
1. Open the IS281StatExam1 workbook, and then save the file as Lastname_Exam1 (For
example, Johnson_Exam1 if your last name is Johnson).
2. On the worksheet ‘Part A’, enter your name in cell B2.
3. Enter the current date in cell B3.
B. Creating a Histogram [6]
The data in the worksheet ‘Part B’ represents the exam scores for a statistics class taught at a
community college.
1. Make a histogram of the time. Insert the histogram in a new worksheet and name this
worksheet ‘Statistics Scores’.
2. Describe the shape of the histogram. Is it unimodal, bimodal, or multimodal? Is the
distribution skewed? If so, in what direction? Are there any outliers?
C. Descriptive Statistics [4]
The worksheet ‘Part C’ shows the number of minutes that 50 Verizon Wireless customers used
on their cell phone accounts last month.
1. Run the descriptive statistics for the data using the Data Analysis tool in Microsoft Excel.
2. Based on the mean and median, is the data symmetric or skewed? If skewed, in which
direction?
D. Binomial Distribution [4]
A fair coin is tossed 15 times and obtaining ‘tails’ is considered as success.
1. In the worksheet ‘Part D’, find the probability that the number of tosses that result in heads
is equal to a specific number (0, 1, 2, 3,….., or 15).
2. Looking at the probabilities, which outcomes are more likely?
E. Poisson Distribution [2]
A customer support center for a computer manufacturer receives an average of 1.5 phone calls
every five minutes. Let X be the number of calls received.
1. In the worksheet ‘Part E’, find the probability for 1 to 10 injuries will arrive during the next
five minutes.
F. Standardizing Data [5]
The data in the worksheet ‘Part F’ represents the number of customers per day at a jewelry kiosk
in a mall during a 50-day period.
1. Calculate the mean and standard deviation for this data in cells E1 and E2 respectively.
2. Using the values in cells E1 and E2, standardize the data.
G. Paired Sample t-Test [8]
A new golf professional was hired to give lessons at Pike Creek Golf Club. The data in the
worksheet ‘Part G’ represents the golf scores of nine people before and after a lesson given by
the new golf professional. At a 0.05 level of significance, is there evidence of a difference in the
average golf score for these individuals after the lesson when compared with before the lesson?
1. Run a paired t-test using the Data Analysis feature in Microsoft Excel.
2. Is this a left-tailed, two-tailed, or right-tailed test?
3. What are the test statistic and the critical value?
4. By comparing the test statistic and the critical value, can you conclude that there is a
difference between the average golf score for these individuals after the lesson when
compared with before the lesson?
A. Documentation [1]
1. Open the IS281StatExam1 workbook, and then save the file as Lastname_Exam1 (For
example, Johnson_Exam1 if your last name is Johnson).
2. On the worksheet ‘Part A’, enter your name in cell B2.
3. Enter the current date in cell B3.
B. Creating a Histogram [6]
The data in the worksheet ‘Part B’ represents the exam scores for a statistics class taught at a
community college.
1. Make a histogram of the time. Insert the histogram in a new worksheet and name this
worksheet ‘Statistics Scores’.
2. Describe the shape of the histogram. Is it unimodal, bimodal, or multimodal? Is the
distribution skewed? If so, in what direction? Are there any outliers?
C. Descriptive Statistics [4]
The worksheet ‘Part C’ shows the number of minutes that 50 Verizon Wireless customers used
on their cell phone accounts last month.
1. Run the descriptive statistics for the data using the Data Analysis tool in Microsoft Excel.
2. Based on the mean and median, is the data symmetric or skewed? If skewed, in which
direction?
D. Binomial Distribution [4]
A fair coin is tossed 15 times and obtaining ‘tails’ is considered as success.
1. In the worksheet ‘Part D’, find the probability that the number of tosses that result in heads
is equal to a specific number (0, 1, 2, 3,….., or 15).
2. Looking at the probabilities, which outcomes are more likely?
E. Poisson Distribution [2]
A customer support center for a computer manufacturer receives an average of 1.5 phone calls
every five minutes. Let X be the number of calls received.
1. In the worksheet ‘Part E’, find the probability for 1 to 10 injuries will arrive during the next
five minutes.
F. Standardizing Data [5]
The data in the worksheet ‘Part F’ represents the number of customers per day at a jewelry kiosk
in a mall during a 50-day period.
1. Calculate the mean and standard deviation for this data in cells E1 and E2 respectively.
2. Using the values in cells E1 and E2, standardize the data.
G. Paired Sample t-Test [8]
A new golf professional was hired to give lessons at Pike Creek Golf Club. The data in the
worksheet ‘Part G’ represents the golf scores of nine people before and after a lesson given by
the new golf professional. At a 0.05 level of significance, is there evidence of a difference in the
average golf score for these individuals after the lesson when compared with before the lesson?
1. Run a paired t-test using the Data Analysis feature in Microsoft Excel.
2. Is this a left-tailed, two-tailed, or right-tailed test?
3. What are the test statistic and the critical value?
4. By comparing the test statistic and the critical value, can you conclude that there is a
difference between the average golf score for these individuals after the lesson when
compared with before the lesson?

Purchase answer to see full
attachment