Question

In: Statistics and Probability

Using your preferred technology format (StatCrunch, Statdisk, Excel), generate a scatterplot for these two data sets....

Using your preferred technology format (StatCrunch, Statdisk, Excel), generate a scatterplot for these two data sets. Based on the graph, do you believe the two sets are correlated?

Now, complete a hypothesis test to test the claim that the course rating and the professor rating are correlated. Explain your conclusion in statistical and non-statistical terms and how you arrived at that conclusion. You should include your null and alternative hypothesis (in English and in symbolic form), your significance level, whether you are conducting a right tailed, left tailed, or two tailed test, r-value, p-value, and conclusions.

COURSE EVAL   PROF EVAL
4.3   4.7
4.5   4.6
3.7   4.1
4.3   4.5
4.4   4.8
4.2   4.4
4   4.4
3.4   3.4
4.7   4.8
3.9   4
3.1   3.6
4   4.1
3.8   4.1
3.4   3.5
2.9   2.9
4.5   4.6
4   4.4
3.8   4
4.3   4.9
3.4   3.5
3.4   3.7
3.3   3.4
4.3   4.3
4.4   4.5
4.1   4.3
4.6   4.8
4.2   4.4
4   4.4
3.3   3.6
4.4   4.6
2.3   2.3
3.5   4.3
4.7   4.9
3.9   4.2
4   4.2
4.3   4.3
3.8   3.9
3.8   3.9
4   4.1
4.6   4.8
3.5   3.3
4.7   4.4
3.4   3.3
3.9   4
4.5   4.5
4.7   4.9
3.5   3.7
3.7   3.9
4   4.4
4.1   4.4
4.4   4.5
4.2   4.3
4.5   4.8
3.8   4.1
3.1   3.5
3.7   4
3.9   3.8
4   4.1
3.3   3.7
3.1   3.2
4   4.2
4.3   4.5
3.7   3.8
3.4   3.7
4.3   4.5
3.7   3.8
4.2   4.5
2.2   2.4
3   3
4.3   4.5
3.5   3.5
4.6   4.8
3.7   4.2
3.8   4
3.6   3.7
4.4   4.5
4.1   4.7
4.3   4.3
4   4
4.8   4.9
3.5   3.5
3.6   3.3
3.8   4.2
4.7   4.8
4.9   4.9
4.3   4.5
3.3   3.3
3.4   3.3
3.6   3.6
4   4.1
3.9   3.7
4.3   4.5
3.3   3.5

Solutions

Expert Solution

Sol:

used R technolgy

create a table course

use cor.test function to get the hypothesis test for correlation

plot function to get the scatteplort in R

Rcode:

course =read.table(header = TRUE, text ="
COURSEEVAL PROFEVAL
4.3 4.7
4.5 4.6
3.7 4.1
4.3 4.5
4.4 4.8
4.2 4.4
4 4.4
3.4 3.4
4.7 4.8
3.9 4
3.1 3.6
4 4.1
3.8 4.1
3.4 3.5
2.9 2.9
4.5 4.6
4 4.4
3.8 4
4.3 4.9
3.4 3.5
3.4 3.7
3.3 3.4
4.3 4.3
4.4 4.5
4.1 4.3
4.6 4.8
4.2 4.4
4 4.4
3.3 3.6
4.4 4.6
2.3 2.3
3.5 4.3
4.7 4.9
3.9 4.2
4 4.2
4.3 4.3
3.8 3.9
3.8 3.9
4 4.1
4.6 4.8
3.5 3.3
4.7 4.4
3.4 3.3
3.9 4
4.5 4.5
4.7 4.9
3.5 3.7
3.7 3.9
4 4.4
4.1 4.4
4.4 4.5
4.2 4.3
4.5 4.8
3.8 4.1
3.1 3.5
3.7 4
3.9 3.8
4 4.1
3.3 3.7
3.1 3.2
4 4.2
4.3 4.5
3.7 3.8
3.4 3.7
4.3 4.5
3.7 3.8
4.2 4.5
2.2 2.4
3 3
4.3 4.5
3.5 3.5
4.6 4.8
3.7 4.2
3.8 4
3.6 3.7
4.4 4.5
4.1 4.7
4.3 4.3
4 4
4.8 4.9
3.5 3.5
3.6 3.3
3.8 4.2
4.7 4.8
4.9 4.9
4.3 4.5
3.3 3.3
3.4 3.3
3.6 3.6
4 4.1
3.9 3.7
4.3 4.5
3.3 3.5
"
)
df1

plot(PROFEVAL~COURSEEVAL,pch=16,data=course,xlab = "COURSEEVAL",
ylab = "PROFEVAL",main="Scatter Plot",col="green")
cor.test(course$COURSEEVAL,course$PROFEVAL)

Output:

Pearson's product-moment correlation

data: x and y
t = 27.246, df = 91, p-value < 2.2e-16
alternative hypothesis: true correlation is not equal to 0
95 percent confidence interval:
0.9162851 0.9624811
sample estimates:
cor
0.943824

Intrepretation:

Form scatterplot the points are clustered

Form:linear

strength:strong

Direction:positive

r=0.9438

Hypothesis test for correlation

Ho:

course rating and the professor rating are not correlated.

Ha:

course rating and the professor rating are correlated.

Its a two tailed test

alpha=0.,05

r=0.943824

n=91

t= 27.246

p-value < 2.2e-16

p value=0.0000

p<0.05

Reject Ho

Accept Ha

Conclusion:There is suffcient statistical evidence at 5% level of significance to conlcude that course rating and the professor rating are correlated.

There exists a strong positve relationship bewteen course rating and professor rating and relationship is statistically significant.


Related Solutions

Test for Correlation - Download the data set “Course Evaluations” in your preferred technology format (StatCrunch,...
Test for Correlation - Download the data set “Course Evaluations” in your preferred technology format (StatCrunch, Statdisk, Excel). Column 2 denotes the mean course rating, and Column 3 denotes the mean professor rating. Using your preferred technology format (StatCrunch, Statdisk, Excel), generate a scatterplot for these two data sets. Based on the graph, do you believe the two sets are correlated? Now, using the same program, complete a hypothesis test to test the claim that the course rating and the...
Provide two columns of data that are related and demonstrate the Excel Scatterplot Correlation and Regression...
Provide two columns of data that are related and demonstrate the Excel Scatterplot Correlation and Regression methodology. Which is the Independent and Dependent variable?
Use StatCrunch and/or Excel (or another software of your choosing) to create a table of summary...
Use StatCrunch and/or Excel (or another software of your choosing) to create a table of summary statistics for all Quantitative variables in the Cleaned Student Data Survey Results that you submitted for Course Project 3. The table should include the following summary statistics: n (count) Mean Standard Deviation 5-Number-Summary (Min, First Quartile, Median, Third Quartile, Maximum) Range (= Max - Min) Inter-Quartile Range (IQR = Q3 - Q1) The table should include these summary statistics for the following variables: Age,...
Data from 5.7: Problem Set 5.7: Scatterplot in SPSS Criterion: Create a scatterplot using SPSS. Data:...
Data from 5.7: Problem Set 5.7: Scatterplot in SPSS Criterion: Create a scatterplot using SPSS. Data: Dr T wanted to see if mindfulness training is related to stress levels. He recruited 10 participants to undergo mindfulness training and examined their reported stress levels on the DRT Stress Inventory. These were his results: Minutes of Mindfulness Training DRT Stress Inventory Score 61 8 122 6 201 3 133 9 55 7 329 1 10 9 1 10 93 7 144 5...
Why is it advisable to generate a scatterplot before computing a correlation coefficient between two variables?...
Why is it advisable to generate a scatterplot before computing a correlation coefficient between two variables? Describe how a scatterplot might differ when viewing correlations that represent positive, negative, and no relationship between predictor and criterion variables. Is it possible to have a relation between variables that systematic (i.e., reliable and predictable) yet not linear?
Why is it advisable to generate a scatterplot before computing a correlation coefficient between two variables?...
Why is it advisable to generate a scatterplot before computing a correlation coefficient between two variables? Describe how a scatterplot might differ when viewing correlations that represent positive, negative, and no relationship between predictor and criterion variables. Is it possible to have a relation between variables that systematic (i.e., reliable and predictable) yet not linear?
Generate and provide your answers to ALL questions using a Microsoft Excel Worksheet(s) and submit this...
Generate and provide your answers to ALL questions using a Microsoft Excel Worksheet(s) and submit this Worksheet as a separate document with your Word document file. Note: You may answer this question in two or more Excel Worksheets – one Worksheet containing the table and the other Worksheet containing all the plots. Alternatively, you may choose to provide each plot in a separate Worksheet.   Demonstrate how the spectral emissive power inside a blackbody cavity changes with respect to the following...
Please present your answers in Excel in a professional format using good titles and proper use...
Please present your answers in Excel in a professional format using good titles and proper use of formulas where necessary.   Pratt, Inc. roasts premium, organic coffee for high-end restaurants. They have three major blends of coffee from the following origins; Ecuador, Peru, and Kenya. They sell the coffee in 10 pound bags and had the following sales prices and volume of sales last year:             Type of coffee             Sales price                   Sales volume Ecuador           =          $ 23.00 / bag               60,000 bags...
Please present your answers in Excel in a professional format using good titles and proper use...
Please present your answers in Excel in a professional format using good titles and proper use of formulas where necessary. Problem #1 Tandy, Inc. is in the business of manufacturing men’s and women’s leather computer bags. On January 1, 2019 they started their new fiscal year. The following is their trial balance as of December 31, 2018:             Account                                               Dr                                Cr             Cash                                                     $   43,200             Accounts Receivable                            $     9,000             Raw Materials Inventory (1)                  $    20,240             Work in...
Hello, I was having trouble combining two stock data sets into excel. If you could please...
Hello, I was having trouble combining two stock data sets into excel. If you could please select a random stock and S&P 500 and conduct the following A.1) From Yahoo Finance’s Historical Data feature, download 5 years of daily data. The measures include Date, Open, High, Low, Close, Adj Close, and Volume. You should download this data for both your stock as well as for the S&P500. A.2) Combine the data in one Excel sheet. Add a prefix to each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT