Question: In the Excel file Freshman College Data, a school wants to predict the first-year retention rate using the high school metrics (ACT and SAT scores,

In the Excel file Freshman College Data, a school wants to predict the first-year retention rate using the high school metrics (ACT and SAT scores, GPA, and the percentage in the top 10% or 20% of their high school classes). Use the Correlation tool to find the correlation matrix for all variables. What can you say about potential multicollinearity? Then identify the best regression model for predicting the first-year retention rate using both the p-value and t-statistic criteria. How do models using the p-value and t-statistic criteria compare?

Step by Step Solution

★★★★★

3.31 Rating (180 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

College Year Avg ACT HS GPA Avg SAT top 10 top 20 1st year retention rate Liberal Arts 2007 2190 3075 104100 1070 1970 6765 Liberal Arts 2008 2191 3170 103644 1345 3057 6710 Liberal Arts 2009 2180 317... View full answer

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 Business Analytics Data Questions!

Using the data in the Excel file Freshman College Data, use ANOVA to determine whether significant differences exist in the mean retention rate for the different colleges over the 4 year period....

Using the data in the Excel file Freshman College Data, identify the best regression model for predicting the first year retention rate. For the model you select, conduct further analysis to check...

Create a sample report to analyze admission and enrollment decisions at the school of arts & letters in a selective four-year college in North America. For predictor variables, include the applicants...

M2.7. COLLEGE FIRST YEAR RETENTION First year retention in a college is affected by many variables including average SAT, high school GPA, % of students in the top 10% of their graduating class, % of...

Object 1 WebAssign Welcome, jeremy.guillory@grandcanyon (log out) Friday, November 18 2016 03:11 AM MST Home My Assignments Grades Communication Calendar My eBooks My Ebooks Introduction to the...

\f3 N | O TC | Q U | EU | S re |Ad ER|10 4 3 ERER KC GH ON MT T ON 04d44f7b/1688154712708/PRIME+Missouri+Education +Profile+2023.pdf 2 / 33 | - 100% TABLE OF CONTENTS Executive Summary CO Missouri...

As first described in Problem 2.9, Pathfinder College is a small liberal arts college that wants to improve its admissions process. In particular, too many of its incoming freshmen have failed to...

Every year, millions of high school students apply and vie for acceptance to a college of their choice. For many students and their parents, this requires years of preparation, especially for those...

what is the output of stack and Queue? A program performs the following operations on a stack S and Queue Q: a. S.push(52); b. S.push(52); c. S.push(S.peek()*2); d. System.out.println(S.size());...

What three funding categories are used to estimate life insurance needs? Explain the purpose of each.

1. Name the three substances loaded into the top of the blast furnace.

=+17. Movie budgets. How does the cost of a movie depend on its length? Data on the cost (millions of dollars) and the running time (minutes) for major release films in one recent year are summarized...

In the past week, an ice-cream kiosk sold 15 cups of chocolate flavor, 22 cups of vanilla, and 13 cups of strawberry. a. Estimate the probability of sale of each flavor for the following week. b....

Airbnb is an online marketplace for arranging or offering lodging, primarily homestays, or tourism experiences. Airbnb provides a platform for hosts to accommodate guests with short-term lodging and...

A teacher recorded the amount of time taken by 21 students to complete a sprint race, to the nearest second, as follows: Two students: between 51 and less than 56 seconds Seven students: between 56...

Navel County Choppers, Inc., is experiencing rapid growth. The company expects dividends to grow at 15 percent per year for the next 11 years before leveling off at 6 percent into perpetuity. The...

The bonds issued by North & South bear a coupon rate of 7.5 percent, payable semiannually. The bonds mature in 6.5 years, sell at par, and have a $1,000 face value. What is the yield to maturity?...

So, Kister Electronics had a fixed factory overhead budget for 20X0 of $72 million and the company planned to make and sell 9 million units of a particular communications device. All variable...