Fill a form in 3 easy steps - less than 5 mins.
Posted: May 15th, 2023
Median, mode, graphing
Using the Unit 1 Discussion Excel workbook, generate your random data set. The data set you create will represent the IQs of a sample of 30 people.Using the data set that you generated in Excel and the Data Analysis Toolpak (see the video on \”Adding the Data Analysis Toolpak\” in the LiveBinder), calculate the mean, median, mode, standard deviation, variance, range, minimum, and maximum. Also, watch the video \”How to Make a Histogram in Excel\” (also in the LiveBinder) to help you make a histogram of these data, and then answer the following questions:
Insert your descriptive statistics output from Excel within your response (see \”How to Use A Snipping Tool\” video in the LiveBinder).
Insert your histogram from Excel within your response using the snipping tool.
What do the following measures of center tell us about the IQs in the data set (be specific and include the values in your discussion – up to three decimal places): (i) mean (ii) median (iii) mode?
Does the mean appear to be similar or different from the median? Why do you think that is so in the context of IQ scores?
What is the standard deviation (give the actual value – up to three decimal places), and what does it tell us about the IQ scores in the data set?
Describe the shape of the histogram and how it relates to the descriptive statistics you calculated. Be sure to express your thoughts in the context of IQ scores.
How might the information in this IQ scores data set be useful, for example, to a teacher in a classroom? Can you think of any other applications for it?
Make sure to attach the Excel file to your post.
Unit 2
Extending your work from the Unit 1 Discussion, you will now analyze and compare the IQs of three different samples. There are two Unit 2 Discussion videos in the LiveBinderto demonstrate the use of Excel for this discussion. In addition, you will use the Unit 2 Discussion Excel file to complete the following:
A. Create the graphs: Follow the instructions in Unit 2 Discussion video: “Graphical Displays” to generate your three random sample datasets and copy and paste special to a new Excel workbook that you will save to your computer. In the new workbook, you will follow the video instructions to generate an appropriate graphical display for all three samples. Then you can use the snipping tool to copy and paste your graphs directly into the body of your discussion post.
B. Describe the graphs:
a. Shape: Describe the shape of the graph (skewness or symmetry) for each group and anything unusual that you see.
b. Center: From the graphs, estimate the center of each group (median and mean) and order the three groups from smallest to largest center. Do you think the mean and median are similar in each group, or is there some group where you think the mean and median will differ? Explain your reasoning.
c. Spread: From the graphs, estimate the spread of each group (range=max-min or IQR=Q3-Q1) and order the three groups from smallest to largest spread.
C. Create numerical summaries: Follow the instructions in Unit 2 Discussion video: “Numerical Summaries” to generate descriptive statistics for each of the three groups. Then you can use the snipping tool to copy and paste your statistics directly into the body of your discussion post.
D. Describe the numerical summaries:
a. Center: Compare and contrast the central tendency (medians and means) of the three groups. Put them in order from smallest to largest center. Is this order what you expected based on your estimates in part B? If it differs, describe the differences.
b. Spread: Compare and contrast the spread (range=max-min and standard deviation) of the three groups. Put them in order from smallest to largest spread. Is this order what you expected based on your estimates in part B? If it differs, describe the differences.
E. Inference: Based on what you said in parts B and D, do all three of your sample groups seem like they could have come from the same population? Do any of the groups seem like they could have come from a different population? Explain your response using the statistics and graphs you generated. Make sure to attach your .XLS file to your post.
Every student wants the best grades and that’s our Focus
Our team consists of outstanding writers who have specialized knowledge in specific subject areas and academic research writing experience. They all hold at least a graduate degree and have been carefully selected to ensure the quality of our work. .
We are committed to hiring the most skilled writers who can deliver high-quality work at a reasonable price. Thus, we offer the best value for money without sacrificing the standard of our services. Our prices are suitable for students and competitive with other writing services in the industry.
The service guarantees that our final work is 100% original. We are committed to delivering plagiarism-free and AI-free work to our esteemed clients. To uphold this promise, we check every draft for any possible instances of duplication or artificiality before we send it to you. You can rely on us to produce genuine and high-standard content for your academic needs.
When you decide to place an order with Homework Ace Tutors, here is what happens: