statistics
Budget: $10 – $30 USD
1. 1-Assume you have a population of 100 students, and you have collected data about four variables as follows:
Variable 1:
“Gender” using the function “=RANDBETWEEN(1,2)” where the value “1” means male and the value “2” means female.
Variable 2:
“Major” using the function “=RANDBETWEEN(1,3)” where the value “1” means “Finance”, the value “2” means “Accounting”, and the value “3” means “Marketing”.
Variable 3:
“Course Grade” using 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:
“Credit Hours Registered” using 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-Collect a sample of size 25 students.
2. 3-Construct relative frequency distributions for variables “Gender” and “Major”.
3. 4-Use bar chart and pie chart to display information in (2).
4. 5-Using population data, construct grouped data frequency distributions for variables “Course Grade” and “Credit Registered”. The frequency distribution must include frequency, relative frequency, cumulative frequency, and cumulative relative frequency.
5. 6-Using population data, present the variable “Credit Registered” and the variable “Course Grade” using two histograms. Each histogram is for each variable.
6. 7-Collect 10 samples of size 25 for variables “Course Grade” and “Credit Registered”.
7. 8-Compare the mean and the standard deviation of the sample means to results computed form the population.
8. 9-Based on a sample of 25, compute the probability that the sample mean for “Course Grade” is between 65 and 80.
Variable 1:
“Gender” using the function “=RANDBETWEEN(1,2)” where the value “1” means male and the value “2” means female.
Variable 2:
“Major” using the function “=RANDBETWEEN(1,3)” where the value “1” means “Finance”, the value “2” means “Accounting”, and the value “3” means “Marketing”.
Variable 3:
“Course Grade” using 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:
“Credit Hours Registered” using 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-Collect a sample of size 25 students.
2. 3-Construct relative frequency distributions for variables “Gender” and “Major”.
3. 4-Use bar chart and pie chart to display information in (2).
4. 5-Using population data, construct grouped data frequency distributions for variables “Course Grade” and “Credit Registered”. The frequency distribution must include frequency, relative frequency, cumulative frequency, and cumulative relative frequency.
5. 6-Using population data, present the variable “Credit Registered” and the variable “Course Grade” using two histograms. Each histogram is for each variable.
6. 7-Collect 10 samples of size 25 for variables “Course Grade” and “Credit Registered”.
7. 8-Compare the mean and the standard deviation of the sample means to results computed form the population.
8. 9-Based on a sample of 25, compute the probability that the sample mean for “Course Grade” is between 65 and 80.