How do you find Quartiles Q1 and Q3 on an Excel sheet with multiple sheets? The info I need is on Data sheet but i need to put it on Data Analysis sheet.
AutoSave . Off) G Spreadsheet Assignment - Education Spending Mini Session (2) - Excel Search Packard, Kaitlin H PK File Home Insert Draw Page Layout Formulas Data Review View Help Analytic Solver 15 Share Comments - 11 General Conditional Formatting Insert v AY I U ~ A E Format as Table aste B A Delete Ideas Sensitivity MA Cell Styles v Format Clipboard Font Alignment Numbe Styles Cells Editing Ideas Sensitivity D32 X V fx =QUARTILE(Data!'Data Analysis'!B7:B56) B D G H K M N O P Q R S T U V W 2 3 The data given in tab one can be used to compare education spending by state 4 We cannot use the data as given, however. For example, to compare Texas and Vermont 5 purely on total amount spent would give a false impression of how much each state spends on education because of varied population size. 7 To make a more valid comparison we can calculate spending per capita by dividing total spent 8 by state population. (although this is total state population and not just students it will give a 9 much better basis for comparison). 10 11 Question1 (5 points): 12 Create a column showing spending per capita. Please be sure and note that spending is in billions 13 and population is in millions. Also note that there are two spending columns which need to be combined. 14 Place this column in the right part of this spreadsheet 15 16 Question 2 (10 points): 17 Provide descriptive statistics for the per capita spending. 18 Calculations using EXCEL functions must be shown. 19 Explain what each item represents, or give a definition in your own words. 20 21 Mean: 22 Median: 23 Mode: 24 Range: 25 Standard Deviation: 26 27 Comparing the mean to the median, is this data set likely skewed right, skewed left, or symmetric? 28 29 30 Question 3 (5 points): 31 Using the EXCEL functions provide: 32 Lower Quartile (Q1): =QUARTILE(Data!'Data Analysis"!B7:B56) 33 Upper Quartile (Q3): Data Data Analysis Histograms Is Bivariate + Point windows Ink Work kspace + 100% Type here to search O 9 W X O 1:03 PM 4/11/2020
