Dr. V. noticed that the more frequently a student is late or absent from class the worse he or she performs onthe final exam. He decided to investigate. Dr. V. collected a random sample of 22 students. This sampleincludes the number of times a student is absent and their grades on the final exam. The data can be found inthe Excel file Assignment10.xlsx. Do not use any software that I did not assign.TimesLate/Final ExamAbsentGrade984.0092.501252.00587.001175.002445.0039.001046.001963.00265.00298.001724.50858.002069.505549.002368.5070.00475.50285.0097.00297.00293.5093.50278.00286.00288.00Question 1: Which or the two variables (times absent or grades on the final exam) is the independentvariable and which is the dependent variable?Question 2: Using Microsoft Excel: (Excel file Assignment10.xlsx) SHOW YOUR WORKа.Count the number of XY variables.b. Calculate the mean and sample standard deviation of both the independent and dependent variables.Calculate the correlation coefficient, r, using Excel's CORREL function. Explain what it means.d. Calculate the coefficient of determination, r², using Excel's RSQ function. Explain what it means.с.

1. Since you have asked multiple questions , we will solve the first question for you . If you…

Dr. V. noticed that the more frequently a student is late or absent from class the worse he or she performs on the final exam. He decided to investigate. Dr. V. collected a random sample of 22 students. This sample includes the number of times a student is absent and their grades on the final exam. The data can be found in the Excel file Assignment10.xlsx. Do not use any software that I did not assign. Times Late/ Absent Final Exam Grade 9 84.00 92.50 12 52.00 87.00 11 75.00 24 45.00 7 39.00 10 46.00 19 63.00 2 65.00 98.00 17 24.50 8 58.00 20 69.50 55 49.00 23 68.50 6. 70.00 4 75.50 2 85.00 97.00 97.00 2 93.50 93.50 78.00 2 86.00 88.00 Question 1: Which or the two variables (times absent or grades on the final exam) is the independent variable and which is the dependent variable? Question 2: Using Microsoft Excel: (Excel file Assignment10.xlsx) SHOW YOUR WORK а. Count the number of XY variables. b. Calculate the mean and sample standard deviation of both the independent and dependent variables. Calculate the correlation coefficient, r, using Excel's CORREL function. Explain what it means. d. Calculate the coefficient of determination, r², using Excel's RSQ function. Explain what it means. с.

Dr. V. noticed that the more frequently a student is late or absent from class the worse he or she performs on the final exam. He decided to investigate. Dr. V. collected a random sample of 22 students. This sample includes the number of times a student is absent and their grades on the final exam. The data can be found in the Excel file Assignment10.xlsx. Do not use any software that I did not assign. Times Late/ Absent Final Exam Grade 9 84.00 92.50 12 52.00 87.00 11 75.00 24 45.00 7 39.00 10 46.00 19 63.00 2 65.00 98.00 17 24.50 8 58.00 20 69.50 55 49.00 23 68.50 6. 70.00 4 75.50 2 85.00 97.00 97.00 2 93.50 93.50 78.00 2 86.00 88.00 Question 1: Which or the two variables (times absent or grades on the final exam) is the independent variable and which is the dependent variable? Question 2: Using Microsoft Excel: (Excel file Assignment10.xlsx) SHOW YOUR WORK а. Count the number of XY variables. b. Calculate the mean and sample standard deviation of both the independent and dependent variables. Calculate the correlation coefficient, r, using Excel's CORREL function. Explain what it means. d. Calculate the coefficient of determination, r², using Excel's RSQ function. Explain what it means. с.

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

*BOLD MEANS I NEED HELP ON THIS SECTION. PLEASE LOOK AT IMAGES. The Stanford University Heart Transplant Study (1974) was conducted to determine whether an experimental heart transplant program increased lifespan. Each patient entering the program was designated an official heart transplant candidate, meaning that he was gravely ill and would most likely benefit from a new heart. Some patients got a transplant and some did not. Of the 34 patients in the control group, 4 were alive at the end of the study. Of the 69 patients in the treatment group, 24 were alive. The contingency table below summarizes these results. Control Treatment Total Alive 4 24 28 Dead 30 45 75 Total 34 69 103 a) What proportion of patients in the treatment group were still alive at the end of the study? .348Correct (Round to three decimal places.)b) What proportion of patients in the control group were still alive at the end of the study? .118 (Round to three decimal places.)c) What are the claims…
The foreign automobile dealer sells English, French, German, Japanese and Korean automobiels. Th enumber of such automobiles sold in a month follow; Country English French German Japanese Korean Number 3. 12 20 10 In words describe what descriptive method would you use to display the data to an audience? Comment on your choice. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
Use the figure to the right, which shows the percentages of adults from several countries who favor building new nuclear power plants in their country. The survey included random samples of 1051 adults from Country A, 1120 adults from Country B, 1048 adults from Country C, and 1013 adults from Country D. At a =0.05, can you support the claim that the proportion of adults in Country B who favor building new nuclear power plants in their country is different from the proportion of adults from Country C who favor building new nuclear power plants in their country? Assume the random samples are independent. 100- 80- 60 40 20- 0- I Country A 53% I Country B 47% O Country C 46% O Country D 34% Identify the claim and state Ho and Ha. The claim is "the proportion of adults in Country B who favor building new nuclear power plants in their country is the same as the proportion of adults from Country C who favor building new nuclear power plants in their country." greater than less than different…
Please explain
If a students rank in a class of 200 is 12, find the students percentile rank
The question is in the image
The table pertains to scheduled commercial carriers. Fatalities data include those on the ground except for the September 11, 2001, terrorist attacks. Use this information given in the table. For fatalities the mean an = 66.7 the median = 14.5 and the mode = 2 2. The year 2001 was clearly an anomaly. If the data for that year is reduced by 239 fatalities, which of the three measures change and what are their new values for each of the following? please help:(
Use the figure to the right, which shows the percentages of adults from several countries who favor building new nuclear power plants in their country. The survey included random samples of 1051 adults from Country A, 1120 adults from Country B, 1048 adults from Country C, and 1013 adults from Country D. At a=0.05, can you support the claim that the proportion of adults in Country B who favor building new nuclear power plants in their country is different from the proportion of adults from Country C who favor building new nudear power plants in their country? Assume the random samples are independent. Country A 53% Country B 47% Country C 46% OCountry D 34% Identify the claim and state Ho and H- The claim is "the proportion of adults in Country B who favor building new nuclear power plants in their country is different than the proportion of adults from Country C who favor building new nuclear power plants in their country." Let p, represent the population proportion for Country B and…
Please answer the last three parts of this question.
Please anwser using SPSS!
The blue catfish (Ictalurus Furcatus) is the largest species of North American catfish. The current world record stands at 143 pounds, which was caught in the John H. Kerr Reservoir (Bugg's Island Lake) located in Virginia. According to American Expedition, the average weight of a blue catfish is between 20 to 40 pounds. Given that the largest blue catfish ever caught was at the John H. Kerr Reservoir, you believe that the mean weight of the fish in this reservoir is greater than 40 pounds. Use the data below, which represents the summary statistics for 48 blue catfish caught at this reservoir, and a 0.05 significance level to test the claim that the mean weight of the fish in the John H. Kerr Reservoir is greater than 40 pounds.