Course Project – Part 1
1. Assume you have a population of 100 students, and you have collected data about four
variables as follows:
Variable 1:
ånder5sing the function RANDBETWEEN(1,2)7here the value T means male and
the value ” means female.
Variable 2:
ajor5sing the function RANDBETWEEN(1,3)7here the value T means ©nance
the value ” means ccounting and the value Ô means arketingŠVariable 3:
ïurse Grade5sing the function TRUNC(NORM.INV(RAND(),?,?),0) The value of the
normal distribution mean(?) is any value between 50 and 75, and the value of the
standard deviation (?) is any value between 5 and 8. Make sure that you do not have any
value greater than 100 or less than 0.
Variable 4:
òedit Hours Registered5sing the function TRUNC(NORM.INV(RAND(),?,?),0) The
value of normal distribution mean (?) is any value between 12 and 15, and the value of the
standard deviation (?) is any value between 1.5 and 3. Make sure that you do not have any
value greater than 24 or less than 3.
Once the data set is created, do the following:
1.
2.
3.
4.
5.
6.
7.
8.
Collect a sample of size 25 students.
Construct relative frequency distributions for variables ånder!nd ajorŠUse bar chart and pie chart to display information in (2).
Using population data, construct grouped data frequency distributions for variables
ïurse Grade!nd òedit Registered The frequency distribution must include
frequency, relative frequency, cumulative frequency, and cumulative relative
frequency.
Using population data, present the variable òedit Registered!nd the variable
ïurse Grade5sing two histograms. Each histogram is for each variable.
Collect 10 samples of size 25 for variables ïurse Grade!nd òedit RegisteredŠCompare the mean and the standard deviation of the sample means to results
computed form the population.
Based on a sample of 25, compute the probability that the sample mean for ïurse
Grade)s between 65 and 80.

Purchase answer to see full
attachment