The variable dtotepp1 measures the Total District Expenditures per Pupil in dollars for 2010 fiscal year. Do the following: a. Transform this variable into a new variable (dtoteppK) to measure expenditures in thousands of dollars ($1000) instead of dollars. That is, a one-unit change in the new variable should represent a $1000 change in the original variable. Note: the new variable should not just be a change in the display of the variable in Excel but a conversion of the values from 1000 to 1. b. I have to produce a table with descriptive statistics for this new variable (dtoteppK), including the mean, median, variance, standard deviation, skewness, and kurtosis. c. I have to produce a histogram of the distribution of this new variable i. Instructions can be found here: Microsoft Support - How to Use the Histogram tool in Excel d. What is the best measure of central tendency for this variable? Why? 3. I have to make a new variable dichotomous variable (called dtotepp2) that is coded one if the value is above the mean and 0 if it is below the mean a. I have to create a frequency table with the frequencies for each category 4. Using the variable dtoteppK, create a new ordinal-level variable (named dtotepp4) that has 4 categories, where 1 = Low, 2 = Mid-Low, 3 = Mid-High and 4 = High. Address the following: a. Use the following as the cutoffs for the categories of this new ordinal variable: i. 0.00-8.00 = 1 ii. 8.01-9.50 = 2 iii. 9.51-11.00 = 3 iv. >11.00 = 4 b. Create a table with descriptive statistics for this variable c. Create a histogram for this variable. What is the best measure of central tendency for this variable? Why?

The Datalink is below and can be used to access the information for this question.

https://docs.google.com/spreadsheets/d/1u5JJkxZG0Iu2sZow8lwEPn4MnCdF7-YU/edit?usp=share_link&ouid=106596741055892912212&rtpof=true&sd=true