Data and Probability Distributions

Question 1.

Let's say you were to roll two dice 1000 times.  What is the number of times you would expect the number 7 to appear?

 

Flag question: Spacer

You will need to download the  data_analysis.xlsx  Download data_analysis.xlsx worksheet to complete parts of this homework.  Make sure you create backup copies of the data, as you will be asked to answer several questions about the data, and will want the ability to filter, rearrange, and organize the data however you like, to best answer the questions.

 

Flag question: Question 2

Question 2.

The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  For this question, we want you to focus specifically on the  ash additive.

You should use all of the data in the dataset, but assume that the data is a sample. 

What is the standard deviation (round to the nearest 4 decimal places)?

example 12.33414 --> 12.3341

example 48.39208 --> 48.3921

 

Flag question: Question 3

Question 3.

The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  For this question, we want you to focus specifically on the  air ent admix additive.

What is the mean (round to the nearest 4 decimal places)?  example 48.39208 --> 48.3921

 

Flag question: Question 4

Question 4.

The Analysis1_DescriptiveStats worksheet contains several additives for concrete.  

Which additive shows the highest relative standard deviation?

Group of answer choices

cement

slag

ash

water

superplastic

air_ent_admix

 

Flag question: Question 5

Question 5.

What can you tell us about how the Coefficient of Variation might be related to skewness?  Use the data from the Analysis1_DescriptiveStats worksheet for your answer.

View keyboard shortcuts

pView keyboard shortcutsAccessibility Checker

0 words

</>Switch to the html editorFullscreen

 

Flag question: Question 6

Question 6.

Use the Analysis2_Correlation worksheet for this question.

Compare the most expensive additive (cement) with the overall Strength. 

What patterns to you see?  Does one have to invest heavily in Cement to achieve a strong concrete mixture?

In a sentence or two, what is happening with any outlier groups?  

View keyboard shortcuts

pView keyboard shortcutsAccessibility Checker

0 words

</>Switch to the html editorFullscreen

 

Flag question: Question 7

Question 7.

Use the Analysis3_ShapeAndSkewness worksheet for this question.

Please investigate both Water and Coarseagg as the two additives that seem closest to a normal distribution.  Create histograms for both additives for comparison.

Using any methods you think appropriate, answer the question: "From a statistical standpoint, which variable closest represents a Normal Distribution.

View keyboard shortcuts

pView keyboard shortcutsAccessibility Checker

0 words

</>Switch to the html editorFullscreen

 

Flag question: Spacer

There is a spreadsheet in the data_analysis.xlsx workbook named NormalDistributions, to assist you with these questions.

 

Flag question: Question 8

Question 8.

500 students are getting ready to take the bar exam.  Assume that the scores can be approximated by a normal distribution.  How many students do we expect to be within 2 standard deviations from the mean?  Enter your answer, rounded to the nearest whole number.

 

Flag question: Question 9

Question 9.

During the height of flu season, demand per day for flu vaccinations in the IU Health network is normally distributed with a mean of 1200 vaccinations and std deviation of 55. What is the probability that demand for a particular day will be less than 1100 vaccinations  (round to the nearest 4 decimal places)?

 

Flag question: Question 10

Question 10.

A hospital is trying to improve quality in every area.  One of the metrics they look closely at is the quality of physicians.  Several individual measurements contribute to a physician's quality score, but they have observed physician quality rankings to be normally distributed, with an average quality score of 83, and a standard deviation of 4.8.  A physician score of 94 or better is considered to be exceptional.

What is the probability that a doctor (selected at random) would have a quality score of 94 or higher  (round to the nearest 4 decimal places)?

 

Flag question: Question 11

Question 11.

A hospital is trying to improve quality in every area.  One of the metrics they look closely at is the quality of physicians.  Several individual measurements contribute to a physician's quality score, but they have observed physician quality rankings to be normally distributed, with an average quality score of 83, and a standard deviation of 4.8.  A physician score of 94 or better is considered to be exceptional.

What portion of physicians would have a quality score between 73 and 93 (inclusive)  (round to the nearest 4 decimal places)?

 

Flag question: Spacer

 

Flag question: Question 12

Question 12.

A company's sales force makes 350 sales calls, with 0.20 probability that sale will be made on a call.  What is the probability exactly 70 sales will be made  (round to the nearest 4 decimal places)?

 

Flag question: Question 13

Question 13.

A company's sales force makes 350 sales calls, with 0.20 probability that sale will be made on a call.  What is the combined probability that 60 or fewer or 75 or more will be made  (round to the nearest 4 decimal places)?

 

Flag question: Question 14

Question 14.

A company's sales force makes 350 sales calls, with 0.20 probability that sale will be made on a call.  What is the probability that fewer than 70 will be made  (round to the nearest 4 decimal places)?

 

Flag question: Question 15

Question 15.

A company's sales force makes 350 sales calls, with 0.20 probability that sale will be made on a call.  What is the probability that more than 70 will be made  (round to the nearest 4 decimal places)?

 

Flag question: Spacer

You will need to navigate to the IdeaxShell worksheet, and complete the problem listed.  Once you've finished, answer the next question, then upload your spreadsheet.

 

HINT: This is very similar to the lecture problem and we strongly suggest you set it up like that.

 

Flag question: Question 16

Question 16.

Based on your data table for the IDEAX problem, what is the optimal number of videos to create to maximize expected profit?

Enter your answer as a whole number.

 

Flag question: Question 17

Question 17.

If the company makes a decision to produce 510 promo videos (ignore your answer on the previous problem), what would be the expected total cost  (add both Promo Cost and Expected Post-Production Cost)?

Round to nearest two decimals.

 

Flag question: Question 18

Question 181.

Please upload your data_analysis.xslx worksheet here, so we can grade your work.