Question:

1. Graph a scatterplot with the below data – Use Excel to do scatterplot – You will want to show your x and y data in the graph and the points on the graph. Label the graph with a Title and label the x and y axis titles:
2. A) Paste the Excel graph below
3. B) Describe what the graph tells you about the data – how do you interpret the data from the graph in terms of what it means?

x data in ages: 2, 11, 17, 20, 40

y data of heights in inches:  30, 40, 50, 60, 70

1. Use the below data to find (using an interval of 5 or 6 or as in Excel calls it bin width of 5 or 6): Use the data below only and use your choice of software to do the Histogram – You can use any Histogram tool whether it is Excel or another application from the Internet. Be sure that the Histogram shows the classes and frequencies. Include a Title of your histogram.
2. A) Paste the Histogram below
3. B) Describe what the Histogram means in relation to the data below – what does it tell you about the data and how you can use it to analyze the data?
4. Use the below data to develop (using an interval of 5 = class width of 5) a frequency distribution chart – Use Excel or any other application to develop your Frequency Distribution Chart. The chart must be in a table format from Excel (do not use a bar chart format for this chart).
5. A) Paste the Frequency Distribution Chart below
6. B) Describe what the Frequency Distribution Chart is telling you about the Test scores
7. Using the below data, use Excel to find the Mean, Median, and Standard Deviation.
8. A) List them below,
9. B) Describe what each of these mean and interpret them in relation to the Test Score data.
1. A) Find the Range, Variance, and Standard Deviation of the below data (Vision Test Scores) – use Excel and Descriptive Statistics in Data Analysis within Excel (Remember to get to Descriptive Statistics in Data Analysis you have to click on the Data button on the top menu of Excel and Data Analysis will be on the top right of Excel)
2. B) Describe what the Range, Variance, and Standard Deviation are telling you about the age range data below…
1. Complete items a and b in the below problem (Note: the z score formula = Z (x) = (x – mean) / (standard deviation)
1. Use the below list of data of Age Ranges to find the percentile for Quartile 1 (25th percentile), Quartile 2 (50th percentile or Median), Quartile 3 (7th percentile) using Excel
2. Notice that the data is already ordered (use the =quartile.exc formula)
3. A) List Q1, Q2 and Q3
4. B) How many people are below Q1 and how many people are above Q3?
1. Use the below list of data Age Ranges to find percentile P20 i.e., 20th Percentile Use the formula in (=percentile.exc) Excel
2.  A) What is the 20th percentile
3.  B) How many people are above the 20th percentile? (Note: you must order your data from small to big complete)
1. List out the A) 5 Number Summary
2. B) graph a Boxplot with the below data – Use Excel for the 5-number summary and you can draw, use Excel or use Paint for the Boxplot or use any other application on the Internet for the boxplot (just copy and paste it below) – Label your box plot as Age Ranges

5 Number Summary (Note: a 5-number summary includes the five numbers of Minimum, Q1, Q2, Q3, and Maximum)

Boxplot –

1. Below are the results of a survey of individuals who refused and responded to a survey.
2. A) What is the probability that a selected person refused to answer – To solve, use the functional definition of a probability
3. B) What does this probability mean?

Part 2

1. A “standard” deck of playing cards consists of 52 Cards in each of the 4 suits of Spades, Hearts, Diamonds, and Clubs. Each suit contains 13 cards: Ace, 2, 3, 4, 5, 6, 7, 8, 9, 10, Jack, Queen, King.
2. What is the probability of getting a diamond card with numbers {2, 3, 4, 5, 6} from a standard deck of playing cards?
1. If the weather man/woman gives a prediction of a 49% chance of rain tomorrow, what is the probability that it will not rain tomorrow?
2. The formal addition rule says P (A or B) = P(A) + P(B) – P (A and B) where P (A and B) is thought of as P (A intersection B) and A and B are not disjoint sets.
3. Let event A = {1,3,5} and event B= {numbers 3, 5 on a six-sided die}. Find P (A or B). What is P (A or B)?
1. Assume that we have a batch of 10,000 heart pacemakers including 9,950 that are good (G) and 50 that are defective.
2. If four of those 10,000 pacemakers are randomly selected without replacement, find the probability that they are all good (use the multiplication rule)
1. Given the survey data from a hospital about taking vitamins per month:

X |#vitamins per month|  3        6         15       30

Probabilities                .10     .30       .50      .10

1. What is the Expected value for this distribution?
2. B) What does the Expected Value answer mean if you are selling vitamins to this hospital?