# In cell h13 insert a function that will determine the

• Homework Help
• 2
• 100% (14) 14 out of 14 people found this document helpful

This preview shows page 1 - 2 out of 2 pages.

In cell H13, insert a function that will determine the first salary range quartiles for teachers [remaining formulas will autocomplete].
In cell J9, use the CORREL function to test for a correlation between test scores and attendance. =CORREL(C4:C53,F4:F53)Select the range I12:I14 and simultaneously insert the FREQUENCY function in all of the cells
to determine the frequency of student absences based on the criteria in the range H12:H14. Divide the function by the number of records in the data to calculate the results as percentages.Select I12:I14, Type in I12 =FREQUENCY(F4:F53,H12:H14)/50CTRL+SHIFT+ENTER=FREQUENCY(F4:F50,H12:H14)/47Load the Analysis Toolpak Add-In. File, Options, Add Ins, Excel Add Ins, ToolpakUse Anova: Single Factor within the Analysis ToolPak to complete an analysis of variance of a cross section data sample of SAT scores from three high schools in the school district. Output theresults in cell F7.