Question

In: Statistics and Probability

The statistics department is interested in the different factors that might influence a student’s score on...

The statistics department is interested in the different factors that might influence a student’s score on the final exam. They identify three factors to test: the student’s midterm exam score, the number of hours the student reports having studied for the final exam, and the average number of drinks of alcohol the student reports having on a night out. They collect data on all of these factors and want to estimate the following model:

FinalExamScore=β0+β1 MidtermExamScore +β2HourStudied +β3AverageAlcohol +ε

Variable Descriptions:

Final Exam Score: A student’s final exam score, measured in % on scale from 0 – 100

Midterm Exam Score: A student’s midterm exam score, measured in % on scale from 0 – 100

Hour Studied: The number of hours the student reports studying for the final exam

Average Alcohol: The average number of alcoholic drinks the student reports having on a typical night out.

For this question, you will need to download the Student Grade Data and then use the data analysis tool pack in Excel to run a regression. Note, you will need to install the data analysis tool pack on your computer. How to do this differs based on the type of computer you are using, but instructions can be found on google for both Mac and PC.

https://arizona.grtep.com/core/uploadfiles/components/282918/files/Student%20Grade%20Data.xlsx (Student Grade Data)

Estimate the sample regression equation above and fill in the estimated coefficients. Round the coefficient estimates to 4 decimals.

FinalExamˆScore=_______+_______MidtermExamScore+_____HourStudied−______AverageAlcohol

Predict a student’s final exam score who scored a 79% on the midterm, studied for 15 hours, and who only drinks 2 drinks on an average night out. Round your answer to 2 decimals. Hint, be sure to use your coefficients that were rounded to 4 decimal points.

Solutions

Expert Solution

In the Excel sheet Student Grade Data.xlsx,

1. Go to Data->Data Analysis->Regression

2. Select Column E (without header) as the Y-range and columns B-D as the X-range in the regression window. Click Ok. We get the following regression output:

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 61.94450208 4.774682548 12.9735331 4.70816E-24 52.48408066 71.40492351 52.48408066 71.40492351
Midterm Exam (%) 0.255280196 0.052624245 4.850999688 3.99773E-06 0.151012 0.359548391 0.151012 0.359548391
Hours Studied 1.001458762 0.148987603 6.721759023 7.86573E-10 0.706258926 1.296658599 0.706258926 1.296658599
Average Alcohol Use -2.882248037 0.351040694 -8.210580965 4.19857E-13 -3.577790174 -2.186705901 -3.577790174 -2.186705901

From the above output,

FinalExamScore = 61.9445 + 0.2553*MidtermExamScore + 1.0015*HourStudied - 2.8822*AverageAlcohol

Now, given a student who scored a 79% on the midterm, studied for 15 hours, and who only drinks 2 drinks on an average night out. Plugging these values into the above regression equation,

Final Exam Score of the student = 61.9445 + 0.2553*79 + 1.0015*15- 2.8822*2 = 91.37%

orchestra answered 1 year ago
Next > < Previous

Related Solutions

An investigator in the Statistics Department of a large university is interested in the effect of...
An investigator in the Statistics Department of a large university is interested in the effect of exercise in maintaining mental ability. She decides to study the faculty members aged 40 to 50 at his university, looking separately at two groups: The ones that exercise regularly, and the ones that don’t. There turn out to be several hundred people in each group, so she takes simple random sample of 25 persons from each group, for detailed study. One of the things...
An investigator in the Statistics Department of a large university is interested in the effect of...
An investigator in the Statistics Department of a large university is interested in the effect of exercise in maintaining mental ability. She decides to study the faculty members aged 40 to 50 at his university, looking separately at two groups: The ones that exercise regularly, and the ones that don’t. There turn out to be several hundred people in each group, so she takes simple random sample of 25 persons from each group, for detailed study. One of the things...
A group of researchers is interested in studying the factors that influence juvenile delinquency. They create...
A group of researchers is interested in studying the factors that influence juvenile delinquency. They create a survey for high school students in a local after-school program. The survey includes questions about age (in years), favorite sports, number of siblings, high school grade point average and the marital status of parents. List the variables in the survey and the level of measurement for each variable.
The researcher from the Annenberg School of Communications is interested in studying the factors that influence...
The researcher from the Annenberg School of Communications is interested in studying the factors that influence how much time people spend talking on their smartphones. She believes that gender might be one factor that influences phone conversation time. She specifically hypothesizes that women and men spend different amounts of time talking on their phones. The researcher conducts a new study and obtains data from a random sample of adults from two groups identified as women and men. She finds that...
Study Time and Exam Score An elementary statistics instructor is interested in determining how well the...
Study Time and Exam Score An elementary statistics instructor is interested in determining how well the amount of time students spend studying for her class predicts their results on exam. The instructor asks her students to keep track of the number of hours they spent working on their statistics course between the first and second exam (including in class time, tutoring time, computer time, etc.) She then recorded their score on the second exam and the results are shown below....
What are the different legal forms of business that you might consider? You remember that there are at least six factors that will influence your choice:
  Creating Sunburst: Legal and Organizational Considerations Ravi, who has a degree from State University in mechanical engineering, was previously employed by a start-up firm in New York City. He worked long hours for little pay, but when the business sold, his stock options paid off. As a result, he now has some time and $100,000 to invest in Sunburst. More importantly, Ravi has the knowledge and know-how to setup and manage production. Tanya, a friend you met through your...
A researcher is interested in whether or not there is a difference in student’s performance based...
A researcher is interested in whether or not there is a difference in student’s performance based on the study methods they use. Participants are assigned one of three different study methods (read the text and re-read it, read and answer prepared questions, and read then create your own questions). There are 6 people in each group and the researcher measures the participants’ performance on a test. Perform a hypothesis test and show all four steps. Hints: Use a two tailed...
List the factors that might influence a firm’s choice of capital structure in the real life...
List the factors that might influence a firm’s choice of capital structure in the real life and explain how each factor affects the optimal leverage ratio in the context of tradeoff theory.
List the factors that might influence a firm’s choice of capital structure in the real life...
List the factors that might influence a firm’s choice of capital structure in the real life and explain how each factor affects the optimal leverage ratio in the context of tradeoff theory.
Post a brief description of factors that might influence and create distortions of memory. Then explain...
Post a brief description of factors that might influence and create distortions of memory. Then explain how one of those factors might create a memory distortion. Provide an example to support your response. Finally, explain three consequences of memory distortion in the context of eyewitness testimony.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT