Analyzing FTES Data: Quartile and Median Calculation in Excel

.docx

School

Maryville University *

*We aren’t endorsed by this school

Course

302

Subject

Statistics

Date

Jun 13, 2024

Type

docx

Pages

2

Uploaded by gigwe0310

The population FTES for 2005–2006 through 2010–2011 was given in an updated report. The data are reported here. See Attached Excel for Data. FTES data.xlsx Use the Excel function to find the First Quartile First Quartile: ___1702.5___ Calculate the first quartile. Round to one decimal place. Hide question 2 feedback use =QUARTILE.INC( , 1) function in Excel. Question 3 0 / 1 point The population FTES for 2005–2006 through 2010–2011 was given in an updated report. The data are reported here. See Attached Excel for Data. FTES data.xlsx Calculate the median. Round to one decimal place. Use the Excel function to find the Median. Median: ___1,892.0___Incorrect Response(1814.5)
Hide question 3 feedback use =MEDIAN function in Excel
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
SEE MORE TEXTBOOKS