Question

Expenditure Data (in thousands of dollars' Year 1 2 3 4 5 Public safety General government Total 94,367 11,222 157,849 100,034 9,831 166,754 105,669 10,910 171,030 112,433 11,001 182,867 117,023 10,234 188,981 a. Compute the correlation coefficients for these factors. (use EXCEL) b. Prepare a paragraph interpreting the results.

          Expenditure Data (in thousands of dollars'
Year
1
2
3
4
5
Public safety
General government
Total
94,367
11,222
157,849
100,034
9,831
166,754
105,669
10,910
171,030
112,433
11,001
182,867
117,023
10,234
188,981
a. Compute the correlation coefficients for these factors. (use EXCEL)
b. Prepare a paragraph interpreting the results.

Expenditure Data (in thousands of dollars'
Year
1
2
3
4
5
Public safety
General government
Total
94,367
11,222
157,849
100,034
9,831
166,754
105,669
10,910
171,030
112,433
11,001
182,867
117,023
10,234
188,981
a. Compute the correlation coefficients for these factors. (use EXCEL)
b. Prepare a paragraph interpreting the results.

Added by Tracy R.

Elementary Statistics a Step by Step Approach

Allan G. Bluman 9th Edition

Instant Answer

Solved by Expert Kaylee Mcclellan

04/12/2021

Step 1

Label the columns as "Year", "Public Safety", "General Government", and "Total". Then, input the corresponding expenditure data for each year under the respective columns. Show more…

Show all steps

Thanks for your feedback!

Expenditure Data (in thousands of dollars' a. Compute the correlation coefficients for these factors. (use EXCEL) Expenditure Data (in thousands of dollars Year 1 2 3 4 5 Public safety 94,367 100,034 105,669 112,433 117,023 General government 11,222 9,831 10,910 11,001 10,234 Total 157,849 166,754 171,030 182,867 188,981 a. Compute the correlation coefficients for these factors. (use EXCEL) b. Prepare a paragraph interpreting the results.