Question: 1) A teacher believes that there is a correlation between a student's attendance and the individual's exam scores. The attached table contains the data for

1) A teacher believes that there is a correlation between a student's attendance and the individual's exam scores. The attached table contains the data for a random selection of 15 students. The attendance is measured by number of classes missed. a) [2] Create the scatterplot on your Excel Spreadsheet with title and axis labels. b) [1] Does it appear to be a negative linear correlation? Why or why not? c) [2] Fill out the necessary cells in the spreadsheet to calculate the correlation coefficient. Use both the formula in the formula sheet and the built-in CORREL function in Excel to check your work. List the value here: d) [4] Conduct a 7-step hypothesis test as outlined in the PowerPoint to determine if the population correlation coefficient is statistically significant with e) (2) Find the equation of the regression line. You may use Excel to find and or write the work out below. Equation: f) [1] Use Excel to calculate the coefficient of determination. List it here: 8) [2] What does the value you found for say about the explained and unexplained variations? Write the appropriate sentences. Use slides 8-10 in the section 9.3 PowerPoint as your guide. 1) A teacher believes that there is a correlation between a student's attendance and the individual's exam scores. The attached table contains the data for a random selection of 15 students. The attendance is measured by number of classes missed. a) [2] Create the scatterplot on your Excel Spreadsheet with title and axis labels. b) [1] Does it appear to be a negative linear correlation? Why or why not? c) [2] Fill out the necessary cells in the spreadsheet to calculate the correlation coefficient. Use both the formula in the formula sheet and the built-in CORREL function in Excel to check your work. List the value here: d) [4] Conduct a 7-step hypothesis test as outlined in the PowerPoint to determine if the population correlation coefficient is statistically significant with e) (2) Find the equation of the regression line. You may use Excel to find and or write the work out below. Equation: f) [1] Use Excel to calculate the coefficient of determination. List it here: 8) [2] What does the value you found for say about the explained and unexplained variations? Write the appropriate sentences. Use slides 8-10 in the section 9.3 PowerPoint as your guide

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

- DO NOT SEND CODE THAT HAS ALREADY BEEN POSTED ON CHEGG. THOSE ANSWERS DON'T WORK - DO NOT HAVE COMMENTS IN THE CODE - WRITE CODE IN JAVA Objectives This is one of two major programming projects...

Objectives This is one of two major programming projects this semester. You should NOT collaborate your code / script on this project. While you may ask for assistance in debugging, this project...

# 45 (use Stapplet) 51,57, 59(Stapplet), 61, 69(Stapplet), 75, 80-85 52 CHAPTER 1 DATA ANALYSIS these cereal brands Between what two values 77. Birth does it her student (ed) About what percent of...

Prescott College General Biology Grades EXAM 1 EXAM 2 73 93 89 96 73 53 69 47 87 79 69 70 93 79 70 93 78 81 88 78 82 86 78 76 96 EXAM 3 80 88 91 98 66 46 74 56 79 70 70 65 95 80 73 89 75 90 92 83 86...

can you please help me with this assignment Crete a narrated multimedia presentation using either Power Point, Screencast-o-matic, or Prezi. Remember,narration with audio (not just ppt notes) is...

1-Please provide 5 cross-examination questions for: Chris Moss Dr. Gerry Stein Sydney Payne Terry Preece Leslie Brown Alex Lloyd 2-Explain why/how/if you would use exhibits A, B, C, and D. 3-What...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

Answer the following True/False, Multiple Choice, Fill in blank as QUICKLY AS POSSIBLE*. Please let them be correct answers. No explanation needed. 1 When conducting a one-sample t test, if a sample...

1.In a survey people are asked "Which brand of toothpaste do you prefer?" The data gathered from this question would be what type of data? A.categorical B.quantitative C.continuous 2.A student is...

For the chi-squared distribution, the mean equals df and the standard deviation equals 22(df). a. Explain why, as a rough approximation, for a large df value, 95% of the chi-squared distribution...

Slinky had purchased his first property on 12 February 1984 for $295,000. He used the property solely as a rental property in all relevant years and sold it on 24 November CY for $310,000. Based on...

1 . All other things equal, what is the effect on EPS when a corporation acquires shares of its own stock on the open market? A . No effect if the shares are held as treasury shares B . Increase only...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...