Prof. Fallahtafti
Page 1 of 1
Group Assignment 1
(20 points)
The first group assignment is application exercises related to module 1 (i.e., Descriptive Statistics and
Discrete/Continuous Probability Distributions). You are expected to work in a team meaningfully and
provide one report which answers the following questions. Datasets are available on Canvas.
1.
(10 points)
Assume a new mini business farm in the southern US produces avocados and ships the
production to wholesalers. The number of avocados in boxes varies. Data (the number of avocados in
boxes) for 120 boxes has been recorded. Use the data file (i.e., Dataset_Avocado) and answer the
following questions:
a.
Use Excel and summarize the data (mean, median, mode, and the standard deviation of the weight
per box).
b.
Use Excel and draw a table showing the probability distribution and cumulative probability
distribution of the number of avocados per box (based on available data).
c.
Use Excel and graph the probability distribution.
d.
What is the probability that a randomly chosen box will contain more than 45 and less than 49
avocados (inclusive)?
e.
Two boxes are chosen at random. What is the probability that at least one of them contains at
least 47 avocados?
2.
(10 points)
Assume the amounts of money spent on clothing in a year by students on a particular campus
follow a normal distribution. Use the data file (i.e., dataset_MoneySpentOnClothing) and answer the
following questions:
a.
Use Excel and draw a histogram representing the shape of the distribution.
b.
One student is randomly chosen. What is the probability that the student will spend less than
$500 on clothing in a year?
c.
Another student is randomly chosen. What is the probability that the student will spend more
than $400 on clothing in a year?
d.
Interpret the results in b and c.
e.
What is the probability that a randomly chosen student will spend between $400 and $500 on
clothing in a year?