Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the date below 1. summarize the data using excel descriptive statistics 2. create a histogram for IQ, inclue Normal distribution density curve 3. make

Using the date below

1. summarize the data using excel descriptive statistics

2. create a histogram for IQ, inclue Normal distribution density curve

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

Age Exam Mark Paper Mark Sex Year in College IQ
21 87 83 M 2 80
19 83 80 M 1 100
23 85 86 M 4 98
21 81 75 F 1 76
21 81 75 F 3 82
20 67 68 F 3 99
26 75 88 F 2 120
24 92 78 F 4 115
26 78 92 M 4 126
30 89 95 F 3 129
21 72 80 F 1 86
19 81 65 M 2 80
17 75 77 M 1 70
19 76 85 F 1 99
35 80 83 F 3 99
27 75 60 F 2 60
21 85 80 M 3 89
27 79 75 M 4 70
21 90 93 F 3 140
22 97 95 M 3 165
21 90 82 M 2 115
19 87 86 F 3 119
32 95 90 M 2 120
19 68 57 F 3 89

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance Theory And Practice

Authors: M. Marlow

1st Edition

0030969603, 978-0030969607

More Books

Students also viewed these Finance questions

Question

12. Prove that {e}={e}

Answered: 1 week ago

Question

Distinguish between poor and good positive and neutral messages.

Answered: 1 week ago

Question

Describe the four specific guidelines for using the direct plan.

Answered: 1 week ago