Question

One of the biggest changes in higher education in recent years has been the growth of online universities. The Online Education Database is an independent organization whose mission is to build a comprehensive list of the top accredited online colleges. The following table shows the retention rate (%) and the graduation rate (%) for 29 online colleges. Retention Rate (%) Graduation Rate (%) 7 25 51 25 4 28 29 32 33 33 47 33 63 34 45 36 60 36 62 36 67 36 65 37 78 37 75 38 54 39 45 41 38 44 51 45 69 46 60 47 37 48 63 50 73 51 78 52 48 53 95 55 68 56 100 57 100 61 Run the data using excel and answer the following: 1. Write the regression equation. 2. Interpret the regression constant and regression coefficient. 3. Forecast a value for the dependent variable. 4. Test the significant of the regression coefficient using alpha = .05. 5. Test the overall significant of the regression model. 6. Interpret the coefficient of determination. 7. Are there any indications of a violation of the general linear model? Be specific.

Answer #1

y x1 x2 x3
x4
64 74 22 24
17
43 63 29 15
30
51 78 20 9 25
49 52 17 38
29
39 45 12 19 37
Consider the set of dependent and independent variables given
below. Perform a best subsets regression and choose the most
appropriate model for these data.
Find the most appropriate model for the data. Note that the
coefficient is 0 for any variable that is not included in the
model.
y= _____+...

2a. Describe the sample and population you are studying.
I am studying customers' satisfaction level with their
car insurance plan.
2b. Calculate the sample mean and sample standard deviation for
your variable. Keep at least four decimal places.
2c. Calculate the standard error and the margin of error for a 90%
confidence interval. Keep at least four decimal places.
Data:
36
18
66
43
28
39
47
40
24
46
48
57
36
58
39
62
43
65
74
36...

Dataset:
Husband Wife
53 50
38 34
46 44
30 36
31 23
26 31
29 25
48 51
65 46
29 26
28 23
29 32
25 22
22 21
21 24
43 50
24 27
38 33
33 26
35 29
40 29
27 25
27 24
49 38
48 39
27 27
26 24
40 34
35 37
21 26
32 39
30 28
60 52
36 40
25 23
66 55
52 34
41 40
43 ...

Find the regression equation, letting the first variable be the
predictor (x) variable. Using the listed actress/actor ages in
various years, find the best predicted age of the Best Actor
winner given that the age of the Best Actress winner that year is
29 years. Is the result within 5 years of the actual Best Actor
winner, whose age was 43 years?
Best Actress
29
29
28
62
33
33
47
29
61
22
45
51
Best Actor
43
36...

Part C: Regression and Correlation Analysis
Use the dependent variable (labeled Y) and the independent
variables (labeled X1, X2, and X3) in the data file. Use Excel to
perform the regression and correlation analysis to answer the
following.
Generate a scatterplot for the specified dependent variable (Y)
and the X1 independent variable, including the graph of the "best
fit" line. Interpret.
Determine the equation of the "best fit" line, which describes
the relationship between the dependent variable and the selected...

Use the dependent variable (labeled Y) and the independent
variables (labeled X1, X2, and X3) in the data file. Use Excel to
perform the regression and correlation analysis to answer the
following.
Generate a scatterplot for the specified dependent variable (Y)
and the X1 independent variable, including the graph of the "best
fit" line. Interpret.
Determine the equation of the "best fit" line, which describes
the relationship between the dependent variable and the selected
independent variable.
Determine the coefficient of...

Q1. A clinical trial is run to assess the effects of
different forms of regular exercise on HDL levels in persons
between the ages of 18 and 29. Participants in the study are
randomly assigned to one of three exercise groups - Weight
training, Aerobic exercise, or Stretching/Yoga – and instructed to
follow the program for 8 weeks. Their HDL levels are measured after
8 weeks and are summarized below.
Weight Training
Aerobic Exercise
Stretching/Yoga
48
38
56
49
41...

B. Determine whether or not the table is a valid probability
distribution of a discrete random variable. Explain fully.
X
0.23
0.14
0.17
P(X=x)
-0.22
0.38
0.84
Daily sales of a medium sized restaurant are normally
distributed with a mean of $720 and a standard deviation of
$80.
What is the probability that a randomly selected day will make
a sales of at least $656?
What is the probability that a randomly selected day will make
a sales between $680...

Conduct a two-factor fixed-effects ANOVA to determine if there
are any effects due to A (task type), B (task difficulty), or the
AB interaction (alpha = .01). Conduct Tukey HSD post-hoc
comparison. The following are the scores from the individual cells
of the model:
A₁B₁: 41, 39, 25, 25,
37, 51, 39, 101
A₁ B₂: 46, 54, 97, 93,
51, 36, 29, 69
A₁ B₃: 113, 135, 109,
96, 47, 49, 68, 38
A₂ B₁: 86, 38, 45, 45,
60,...

You are a consultant who works for the Diligent Consulting
Group. In this Case, you are engaged on a consulting basis by
Loving Organic Foods. In order to get a better idea of what might
have motivated customers’ buying habits you are asked to analyze
the factors that impact organic food expenditures. You opt to do
this using linear regression analysis.
Case Assignment
Using Excel, generate regression estimates for the following
model:
Annual Amount Spent on Organic Food = α...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 3 minutes ago

asked 22 minutes ago

asked 24 minutes ago

asked 36 minutes ago

asked 55 minutes 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

asked 2 hours ago