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
Answer #1
Not the answer you're looking for?
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...
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....
Bivariate Data & Probability After completing the calculation by hand in Q1 you can use Excel...
Bivariate Data & Probability
After completing the calculation by hand in Q1 you can use
Excel to check your answers before submitting. Q2 assesses your
general understanding of probability and linear associations using
Excel to analyse a large dataset.
Question 1
Covariance and Correlation
The table below shows a set of sample bivariate data. Calculate
the covariance and correlation coefficient by completing the below
table. Show all working.
X
Y
(X - )
(Y - )
(X - )(Y -...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 29 minutes ago
asked 40 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago