Week 4 problems (bus5250 bus analytics & research methods)

/in /by

Week4Problems.docx

Don't use plagiarized sources. Get Your Custom Essay on
Need an answer from similar question? You have just landed to the most confidential, trustful essay writing service to order the paper from.
Just from $11/Page
Order Now

Week 4 Problems

· Due Saturday, September 15 by 11:59pm


Week 4-College – Data.pdf

Download Week 4-College – Data.pdf

Load manually College data above  in Excel Sheet and manipulate the data to address the following:

1.
Summarize the data using Excel Descriptive Statistics

2.
Create a pie-chart for Year in College

3.
Create a Histogram for IQ, include Normal distribution density curve.

4.
Make a scatter plot with IQ and x-axis and Exam Grade on y-axis, include trend line. What can you conclude?

5.
Make a scatter plot with sex (gender) on the x-axis and IQ on the y-axis, include trend line. What can you conclude?

Problem Guide:

1. You will manipulate and analyze data using Excel or SPSS.

2. You will copy charts, graphs, tables, from Excel or SPSS into a Word document.

3. Write a report on your findings in the Word document referencing the charts, graphs, and tables from Excel or SPSS.

The original questions must be typed out as headings, with follow up answers + charts, graphs, and tables in paragraph format, and a summary or conclusion at the end of the paper. Problems have no references limit and must be in APA format.