View the step-by-step solution to:

The Programme for International Student Assessment (PISA) is a worldwide study by the Organisation for Economic Co-operation and Development (OECD)...

MUST USE EXCEL AND WRITE DOWN THE STEPS IN FINDING, AND PASTE THE excel functions, here is the data set, the google spreadsheet link

https://docs.google.com/spreadsheets/d/1_HwkKjQg4-zQSE9O6m1_mCn1e8dK3l2CwTpoYOD6L6A/edit?usp=sharing

coursehero as 3 3-1.jpg

coursehero as 3 3-3.jpg

coursehero as 3 3-1.jpg

2. The Programme for International Student Assessment (PISA) is a worldwide study by the
Organisation for Economic Co-operation and Development (OECD) in member and non-
member nations intended to evaluate education systems by measuring 15-year-old school
pupils' scholastic performance in Mathematics, Science and Reading.
Refer to Math_and_gender dataset. The dataset contains the mean PISA Math scores for
samples of 15-year-old male and female students from a number of randomly selected schools
in each of various nations.
You are to perform a regression analysis using mean male score as the explanatory
variable and mean female score as the response variable.
(continue next page)

coursehero as 3 3-3.jpg

Perform the following: (d) Produce a residual plot [that is, plot residuals vs male means}. (e) What isfare the purpose(s) of a residual plot in regression analysis? For the residual plot
drawn in part (d), explain what you learn in the context of this problem. (f) Produce a histogram of the residuals. (g) What is the purpose of drawing a histogram of the residuals in regression analysis? For
the histogram of residuals drawn in part (f), explain what you learn. (h) Identify two countries whereby the female students perform much worse than predicted
based on the country's male mean score?

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question