Question: Use the data below to create frequency distribution table using 6 classes. Use the frequency distribution table to find the mean of the distribution as
Use the data below to create frequency distribution table using 6 classes. Use the frequency distribution table to find the mean of the distribution as well as relative frequency, cumulative frequency and cumulative relative frequency. 44 54 67 65 43 45 65 68 79 86 75 64 53 24 13 35 57 79 97 86 75 64 53 42 31 35 42 47 58 79 80
In a huge data lab in New Mexico, numbers ranging from 3-7 appear over and over again. Use the data below to create probability distribution. Find the mean of the distribution as well as the standard deviation of the distribution: Lab numbers Number of occurrences 3 1200 4 500 5 2250 6 1000 7 800
Below is the data of a selected number of restaurants in Los Angeles. Use this to answer the questions below: Quality rating$10-19 $20-29 $30-39 $40-49 total Good 42 40 2 0 84 Very good 34 64 6 6 110 Excellent 2 14 28 22 66 Total 78 118 36 28 260 Find the probability that a restaurant selected is : a) either an excellent restaurant or costs $40-49 per meal on average a) either a good restaurant or costs $20-$29 per meal on average a) An excellent restaurant given that it costs $40-49 per meal on average
Shop Til' U Drop magazine carried out a research and discovered that the 60% of shoppers spends an average of an hour in the Pasadena Mall. Mr. August decides to survey 8 shoppers and asked them how long they spend in the mall. Using the information provided. What is the probability that: a) More than 4 shoppers spend an average of an hour at the mall. b) Up to 4 shoppers spend an average of an hour at the mall. c) Less than 6 shoppers spend an average of an hour at the mall d) What is the average number of shoppers who spend about an hour at the mall?
This should be used in excel. I need help bad.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
