Question

In: Math

Directions: Use the Bivatiate Correlation function and the Options submenu to answer each of the questions...

Directions: Use the Bivatiate Correlation function and the Options submenu to answer each of the questions based on the above scenario.

The superintendent has continued the examination of data by examining the relationship between attendance rate and percent of students eligible for free or reduced priced lunch. The district data used for the analysis are contained below.

School	% Free or Reduced	Attendance Rate
1	47.0	94.8
2	31.1	96.1
3	58.9	94.9
4	40.9	94.2
5	24.1	95.7
6	50.4	94.8
7	54.7	93.8
8	60.1	92.6
9	49.6	93.6
10	42.9	93.8
11	38.1	92.8

School	% Free or Reduced	Attendance Rate
12	27.2	99.7
13	58.4	93.4
14	52.4	93.6
15	58.4	94.6
16	64.9	93.0
17	75.5	92.3
18	30.6	95.1
19	79.4	92.8
20	67.3	92.6
21	56.7	95.5
22	74.7	91.8

What is the mean percent of students receiving free or reduced lunch? What is the mean attendance rate?

51.97 free or reduced

94.16 attendance

What are the standard deviations for the percent of students receiving free or reduced lunch and attendance rate?

15.68 free or reduced

1.71 attendance

State an appropriate null hypothesis for this analysis.

What is the value of the correlation coefficient?

Based on the value of the correlation coefficient, how would you classify the strength of this relationship?

Based on the information from the scenario, what is the appropriate value for the degrees of freedom?

What is the reported level of significance?

Present the results as they might appear in an article. This must include a table and narrative statement that reports and interprets the results of your analysis.

Note: The table must be created using your word processing program. Tables that are copied and pasted from SPSS are not acceptable.

Expert Solution

State an appropriate null hypothesis for this analysis.
Ho: Correlation is equal to zero
H1 : correlation is not equal to zero

What is the value of the correlation coefficient? -0.709961317

Based on the value of the correlation coefficient, how would you classify the strength of this relationship?
It has a strong negative relationship.
that is as one increases the other one decreases.

Based on the information from the scenario, what is the appropriate value for the degrees of freedom? 20
What is the reported level of significance? 0.05

Other calculated statistics given below

Details solution given below

milcah answered 1 year ago

Directions Use the Bivatiate Correlation function and the Options submenu to answer each of the questions...

Directions Use the Bivatiate Correlation function and the Options submenu to answer each of the questions based on the scenario. Scenario The superintendent has continued the examination of data by examining the relationship between attendance rate and percent of students eligible for free or reduced priced lunch. The district data used for the analysis are contained below. School % Free or Reduced Attendance Rate 1 47.2 94.8 2 31.1 96.1 3 58.9 94.9 4 44.9 94.2 5 24.1 95.7 6...

Assignment #6: Testing Correlations Directions: Use the Bivatiate Correlation function and the Options submenu to answer...

Assignment #6: Testing Correlations Directions: Use the Bivatiate Correlation function and the Options submenu to answer each of the questions based on the above scenario. The superintendent has continued the examination of data by examining the relationship between attendance rate and percent of students eligible for free or reduced priced lunch. The district data used for the analysis are contained below. School 1 2 3 4 5 6 7 8 9 10 11 % Free or Reduced 70.4 49.4 58.9 65.1...

Assignment 6: Testing Correlations Directions Use the Bivatiate Correlation function and the Options submenu to answer...

Assignment 6: Testing Correlations Directions Use the Bivatiate Correlation function and the Options submenu to answer each of the questions based on the scenario. Scenario The superintendent has continued the examination of data by examining the relationship between attendance rate and percent of students eligible for free or reduced priced lunch. The district data used for the analysis are contained below. School % Free or Reduced Attendance Rate 1 47.2 94.8 2 31.1 96.1 3 58.9 94.9 4 44.9 94.2...

Directions: Once you answer the Essential Questions above, create and scenario for each answer. Your questions...

Directions: Once you answer the Essential Questions above, create and scenario for each answer. Your questions should help you focus on the different laws, how these laws apply in ethical decision making, and solutions to common workplace problems. Why is health care information protected by law? a). Health information is any information about a person’s health or disability. It is often sensitive and personal, depending upon the intensity of the illness or the type of treatment etc., which is why...

Directions Use the Crosstabs option in the Descriptives menu to answer the questions based on the...

Directions Use the Crosstabs option in the Descriptives menu to answer the questions based on the following scenario. (Be sure to select Chi-square from the Statistics submenu and Observed, Expected, Row, and Column in the Cells submenu. Assume a level of significance of .05). Scenario The school district recently adopted the use of e-textbooks, and the superintendent is interested in determining the level of satisfaction with e-textbooks among students and if there is a relationship between the level of satisfaction...

Directions: Use the Crosstabs option in the Descriptives menu to answer the questions based on the following scenario.

Directions: Use the Crosstabs option in the Descriptives menu to answer the questions based on the following scenario. (Be sure to select Chi-square from the Statistics submenu and Observed, Expected, Row, and Column in the Cells submenu. Assume a level of significance of .05) The school district recently adopted the use of e-textbooks, and the superintendent is interested in determining the level of satisfaction with e-textbooks among students and if there is a relationship between the level of satisfaction...

Directions Use the Chi-Square option in the Nonparametric Tests menu to answer the questions based on...

Directions Use the Chi-Square option in the Nonparametric Tests menu to answer the questions based on the following scenario. (Assume a level of significance of .05 and use information from the scenario to determine the expected frequencies for each category). Scenario During the analysis of the district data, it was determined that one high school had substantially higher Graduate Exit Exam scores than the state average and the averages of high schools in the surrounding districts. To better understand possible...

Network Device Basics Directions: Use Packet Tracer to complete the following labs. Answer the questions and...

Network Device Basics Directions: Use Packet Tracer to complete the following labs. Answer the questions and record screenshots in a Word document titled firstInitial+LastName+Basics. Find Device Information You are working with a single active switch and a router as shown in Diagram 1. You would like to gather information about the device. Execute this lab according to the following guidelines: Use the CLI to answer the following questions: What is the IOS version? How much NVRAM (non-volatile RAM) is available...

Directions Go to the YAHOO! FINANCE page follow the directions below and answer the questions. Type...

Directions Go to the YAHOO! FINANCE page follow the directions below and answer the questions. Type in XOM in the “Get Quotes" box. Click on “Profile” and write a one paragraph description of the company’s activities. Return to the homepage and write down the company’s P/E ratio. Is it relatively low (under 15)? Click on "Competitors" and compare ExxonMobil to other companies in the industry based on the P/E ratio and the PEG ratio (the P/E ratio...

Assignment #1: Descriptive Statistics Directions: Use the Frequencies option in SPSS to answer each of the...

Assignment #1: Descriptive Statistics Directions: Use the Frequencies option in SPSS to answer each of the questions based on the following scenario. Scenario: A superintendent of a school district was requested to present to the school board demographic data based on the schools within the district. One item that the superintendent had to present was the percent of students who were eligible for free or reduced-price lunch (a commonly used proxy for socio-economic status). The following percents were reported for...