Question: PLEASE DO IT ON EXCEL Case Study Researchers wondered whether the size of a person's brain was related to the individual's mental capacity. They selected

PLEASE DO IT ON EXCEL

Case Study

Researchers wondered whether the size of a person's brain was related to the individual's mental capacity. They selected a sample of students who had SAT scores higher than 1350. The subjects took the Wechsler Adult Intelligence Scale-Revised to obtain their IQ scores. MRI scans were performed at the same facility for the subjects. The scans consisted of 18 horizontal MR images. The computer counted all pixels with nonzero gray scale in each of the 18 images, and the total count served as an index for brain size. The result is summarized in the table below.

Gender

MRI Count

Female

816,932

133

Female

951,545

137

Female

991,305

138

Female

833,868

132

Female

856,472

140

Female

852,244

132

Female

790,619

135

Female

866,662

130

Female

857,782

133

Female

948,066

133

Male

949,395

140

Male

1,001,121

140

Male

1,038,437

139

Male

965,353

133

Male

955,466

133

Male

1,079,549

141

Male

924,059

135

Male

955,003

139

Male

935,494

141

Male

949,589

144

Instructions

All questions must be fully answered with supporting work using knowledge acquired in this course and the Excel lab formulas. please use an explanation.

1.Construct a bar graph for each variable and comment

2.Find the mean for each of the quantitative variables and comment

3.Find the 5-number summary for the quantitative variables and comment

4.Find the correlation coefficient between the quantitative variables and explain its meaning in this context.

5.Find the coefficient of determination between the quantitative variables and explain its meaning in this context

6.Compute the standard deviation for each quantitative variable

7.Is there an outlier in the explanatory or in the response variables? Explain your answer.

8.Perform a linear regression for the two quantitative variables, show your output and comment on it

9.Use the output to write the equation of the best-fitted line and explain its meaning in this context

10. Predict the IQ of an individual with MRI Count of 955,000

11. Explain the b₀ and b₁ coefficients in your regression

12. Use this sample to construct a 95% confidence interval for the mean IQ for all students who score 1350 or higher on the SAT and comment your result.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

1. Researchers wondered whether the size of a person's brain was related to the individual's mental capacity. They selected a sample of right-handed introductory psychology students who had SAT...

Instructor: Basu Dipanker Course: MAT-240-Q6622-16EW6 Assignment: 6-2 MyStatLab: Module Six Problem Set 1. Determine whether the scatter diagram indicates that a linear relation may exist between the...

PubH 6002: Biostatistical Applications for Public Health 4. A public health researcher examines the medical records of a group of 937 men who died in 1999 and discovers that 210 of the men died from...

3. For the accompanying data set, (a) draw a scatter diagram of the data, (b) compute the correlation coefficient, and (c) determine whether there is a linear relation between x and y. 1 Click the...

1. Researchers wondered whether the size of a person's brain was related to the individual's mental capacity. They selected a sample of right-handed introductory psychology students who had SAT...

Researchers wondered whether the size of a persons brain was related to the individuals mental capacity. They selected a sample of right-handed introductory psychology students who had SAT scores...

MATH 1342 Elementary Statistical Methods Lab 4 Name ___________________________ A researcher was tasked with determining whether the video display used by travel agents for booking airline...

### Problem 5 HW3 RStudio a) b) c) d) Researchers wondered whether the size of a person's brain was related to the individual's mental capacity. They selected a sample of right-handed introductory...

provide me answers to the following 1. Researchers wondered whether the size of a person's brain was related to the individual's mental capacity. They selected a sample of right-handed introductory...

MATH 1342 Name Elementary Statistical Methods Lab Ch.4 - Linear Regression Critical Thinking; Communication Skills; Empirical/Quantitative Skills 1. Researchers wondered whether the size of a...

What is deforestation? What are four important causes of tropical deforestation?

You have been assigned to Mexico for a two-year international assignment. Your task is to support the development of a new subsidiary. During the first weeks of your stay in Mexico, you experience...

Which of the following statements is not true?The auditor has a right of access to all books and records at all reasonable times.The auditor must report all situations where inadequate records are...

Question 2 Cash Flow Statement The following information relates to Hunter a small private company. It consists of an opening statement of financial position as at 1 April 203 and a listing of the...