Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

MATH399 Statistics

tag 0 Download 2 Pages / 288 Words tag 14-09-2020
  • Course Code: MATH 399
  • University: DeVry University
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: United States

Questions:

Frequency Distributions

  1. Create a frequency table for the variable State.you can click on Data and then Sort and choose State as the variable on which to sort. Once sorted, you can count how many students are from each state. From that table, use a calculator to determine the relative percentages, as well as the cumulative percentages.

Creating Graphs

  1. Create a bar chart for the frequency table in Question 1. Select the State variable values. Click on Insert and then click on the arrow on the bottom right of the Charts area and select Clustered Column and click OK. (Again, different versions of Excel may need different directions.) Add an appropriate title and axis label. Copy and paste the graph here.
  1. Create a pie chart for the variable Car. Select the column with the Car variable, including the title of Car. Click on Insert, and then Recommended Charts. It should show a clustered column and click OK. Once the chart is shown, right click on the chart (main area) and select Change Chart Type. Select Pie and OK. Click on the pie slices, right click Add Data Labels, and select Add Data Callouts. Add an appropriate title. Copy and paste the chart here.
  1. Create a histogram for the variable Height. Use the strategies in the text to create a frequency table of the heights using the categories of 60–64, 65–69, 70–74, and 75–79. It may be helpful to sort the data based on the Height variable first. Create a new worksheet in Excel by clicking on the + along the bottom of the screen and type in the categories and the frequency for each category. Then, select the frequency table, click on Insert, then Recommended Charts and choose the column chart shown and click OK. Right-click on one of the bars and select Format Data Series. In the pop up box, change the Gap Width to 0. Add an appropriate title and axis label. Copy and paste the graph here.
  1. Create a stem and leaf chart for the variable Money, using only the whole dollar amounts. This must be done by hand, as Excel cannot do this type of chart. Using the tens value as the stem and the ones value for the leaves, type a stem and leaf plot into the box below. It may be helpful to sort the data based on the Money variable first.

Calculating Descriptive Statistics

  1. Calculate descriptive statistics for the variable Height by Gender. Click on Insert and then Pivot Table. Click in the top box and select all the data (including labels) from Height through Gender. Also click on new worksheet and then OK. On the right of the new sheet, click on Height and Gender, making sure that Gender is in the Rows box and Height is in the Values Click on the down arrow next to Height in the Values box and select Value Field Settings. In the pop up box, click Average, then OK. Type in the averages below. Then, click on the down arrow next to Height in the Values box again and select Value Field Settings. In the pop up box, click on StdDev then OK. Type the standard deviations below.

 

Mean

Standard Deviation

Females

 

 

Males

 

 

  1. What is the most common color of car for students who participated in this survey? Explain how you arrived at your answer.
  1. What is seen in the histogram created for the heights of students in this class (include the shape)? Explain your answer.
  1. What is seen in the stem and leaf plot for the money variable (including the shape)? Explain your answer.
  1. Compare the mean for the heights of males and the mean for the heights of females in these data. Compare the values and explain what can be concluded based on the numbers.
  1. Compare the standard deviation for the heights of males and the standard deviation for the heights of females in the class. Compare the values and explain what can be concluded based on the numbers.
 
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 2 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). MATH399 Statistics. Retrieved from https://myassignmenthelp.com/free-samples/math399-statistics.

"MATH399 Statistics." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/math399-statistics.

My Assignment Help (2020) MATH399 Statistics [Online]. Available from: https://myassignmenthelp.com/free-samples/math399-statistics
[Accessed 29 September 2022].

My Assignment Help. 'MATH399 Statistics' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/math399-statistics> accessed 29 September 2022.

My Assignment Help. MATH399 Statistics [Internet]. My Assignment Help. 2020 [cited 29 September 2022]. Available from: https://myassignmenthelp.com/free-samples/math399-statistics.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?