Course Project – Part 11. 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.
3.
4.
5.
6.
7.
8.
Collect a sample of size 25 students.
Construct relative frequency distributions for variables “Gender” and “Major”.
Use bar chart and pie chart to display information in (2).
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.
Using population data, present the variable “Credit Registered” and the variable
“Course Grade” using two histograms. Each histogram is for each variable.
Collect 10 samples of size 25 for variables “Course Grade” and “Credit 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 “Course
Grade” is between 65 and 80.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Achiever Papers is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Dissertation Writing Service Works
First, you will need to complete an order form. It's not difficult but, if anything is unclear, you may always chat with us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download