Question

(a) USING CALCULATOR (by hand) OR EXCEL BASIC COMPUTATIONS Write out the regression equation. What is...

(a) USING CALCULATOR (by hand) OR EXCEL BASIC COMPUTATIONS Write out the regression equation. What is the correlation coefficient? What is r-square (coefficient of determination)? Draw the conclusion (very important)

A researcher is interested in determining whether there is a relationship between grades and hours studied for statistics.

Hours studied(X)

Grade on final(Y)

1

20

2

30

4

40

7

60

6

70

7

78

8

83

9

98

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1: Compute measures of central tendency below: a)Mean, median, and mode for the grades taken by...
1: Compute measures of central tendency below: a)Mean, median, and mode for the grades taken by students b)Mean, median, and mode for the number of hours studied Discussion question 2: Does the number of hours studied correlate with the grades taken? Please provide a narrative explaining the relationship between the number of hours studied and the grades by running correlation analysis in Excel. In Excel, use insert function to compute the measures of central tendency and use the CORREL function...
Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put...
Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put below (Note: First enter the data in the next page in an Excel spreadsheet) Home Sale Price: The table below provides the Excel output of a regression analysis of the relationship between Home sale price(Y) measured in thousand dollars and Square feet area (x):    SUMMARY OUTPUT Dependent: Home Price ($1000) SUMMARY OUTPUT Dependent: Home Price ($1000) Regression Statistics Multiple R 0.691 R Square 0.478...
Complete the following problems: Hours 37 29 14 42 34 7 24 21 34 44 29...
Complete the following problems: Hours 37 29 14 42 34 7 24 21 34 44 29 34 26 33 17 21 28 15 33 38 Grade 82 80 42 96 87 30 76 71 92 97 98 57 87 97 48 60 68 70 79 99 An experiment was done to determine if the amount of study hours affect the grade earned by all students in a Business class. Using the above data from the population, find the following: Median,...
Research into the relationship between hours of study and grades show widely different conclusions. A recent...
Research into the relationship between hours of study and grades show widely different conclusions. A recent survey of graduates who wrote the Graduate Management Admissions Test (GMAT) had the following results. Hours Studied Average Score (Midpoint) 64 350 72 450 79 550 106 650 99 750 The Excel output for this regression is as following SUMMART OUTPUT ____________________________    Regression Statistics ____________________________ Multiple R 0.919958 R Square 0.846322 Adjusted R Square 0.795097 Standard Error 71.57225 Observations 5 Anova ___________________________________________________________________________________________   ...
The table below gives the number of hours spent unsupervised each day as well as the...
The table below gives the number of hours spent unsupervised each day as well as the overall grade averages for seven randomly selected middle school students. Using this data, consider the equation of the regression line, yˆ=b0+b1x, for predicting the overall grade average for a middle school student based on the number of hours spent unsupervised each day. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would...
For Exercise 1 through 7, do a complete regression analysis by performing the following steps. a.Draw...
For Exercise 1 through 7, do a complete regression analysis by performing the following steps. a.Draw the scatter plot. b.Compute the value of the correlation coefficient. c.Test the significance of the correlation coefficient at α = 0.01, using Table I or use the P-value method. d.Determine the regression line equation if r is significant. e.Plot the regression line on the scatter plot, if appropriate. f.Predict y′ for a specific value of x, if appropriate. 5.Typing Speed and Word Processing A...
1.   Regression analysis is to be conducted with data from vegetarians to see whether the number...
1.   Regression analysis is to be conducted with data from vegetarians to see whether the number of grams of protein each ate per day was related to diastolic blood pressure.   The resulting regression formula will be used by medical personnel to predict blood pressure in a weight loss clinic in downtown Pittsburgh. Subject Grams of protein Diastolic BP 1 4 73 2 6.5 79 3 5 83 4 5.5 82 5 8 84 6 10 92 7 9 88 8...
A researcher wants to determine the relationship between the typing speed of administrative assistants at a...
A researcher wants to determine the relationship between the typing speed of administrative assistants at a major university is related to the time that it takes for the admin assistant to learn to use a new software program and may be used to predict learning time. Data are gathered from 12 departments at the university. Dept Typing speed   (words per minute) Learning time   (hours) A 48 7 B 74 4 C 52 8 D 79 3.5 E 83 2 F...
Applications I Consider the following data representing the total time (in hours) a student spent on...
Applications I Consider the following data representing the total time (in hours) a student spent on reviewing for the Stat final exam and the actual score on the final. The sample of 10 students was taken from a class and the following answers were reported. time score 0 23 4 30 5 32 7 50 8 45 10 55 12 60 15 70 18 80 20 100 Part 1: Use the formulas provided on the 3rd formula sheet to compute...
1. For a pair of sample x- and y-values, what is the difference between the observed...
1. For a pair of sample x- and y-values, what is the difference between the observed value of y and the predicted value of y? a) An outlier b) The explanatory variable c) A residual d) The response variable 2. Which of the following statements is false: a) The correlation coefficient is unitless. b) A correlation coefficient of 0.62 suggests a stronger correlation than a correlation coefficient of -0.82. c) The correlation coefficient, r, is always between -1 and 1....