Question

Directions: Submitted in PDF format only. Do not submit Excel spreadsheets. Please include ALL prompts in your write up with your response beneath. Respond in complete sentences. Use APA format for all charts. Please BOLD the prompts.

1) Write a few sentences describing a business related population with characteristics that you assume is near normally distributed. State a metric (height, scores, etc ...) that can be used to measure the characteristic.

2) Write a few sentences describing a business related population with characteristics that you assume follows a binomial distribution. Be sure to address all criteria for the distribution. State a metric that can be used to measure the characteristic.

3) Write a few sentences describing a business related population with characteristics that you assume follows a Poisson distribution. Be sure to address all criteria for the distribution. State a metric that can be used to measure the characteristic

4) Use Excel to generate a normally distributed dataset of 300 sample points . DO NOT submit your excel file. Submit the Excel features and arguments you used to generate the dataset. Chose your own mu and sigma.

Hint: See Spreadsheet notes

5) Use Excel to generate a binomial distribution histogram . Choose your own n <5 and choose your own p (see spreadsheet notes). DO NOT submit your excel file. Submit the Excel features and arguments you used to generate the dataset.

6) Use Excel to generate a Poisson distribution histogram . Choose your own n <5 and choose your own lamda (see spreadsheet notes) DO NOT submit your excel file. Submit the Excel features and arguments you used to generate the dataset.

7) Provide visual justification of your normally distributed data created in question #4 by generating a histogram. Discuss the shape of your histogram

8) Use the Empirical rule to determine the range of data where 68% and 95% of the data values created in question #4 are within. Report your ranges and show all calculations used to determine them

Answer 1

(as per the answering policy i am answering the first question)

1.

Business population : 500 ml soft drink bottles

We are measuring the actual amount of softdrink filled in each bottle because the filling machine cannot be completely accurate at all times

Here the population is normally distributed with mean 500ml in each bottle with a standard deviation of 1ml

Here the metric used to measure the characteristic is millilitres (ml) which messages the amount (volume) of softdrink filled in the bottle.

Thanks, please upvote