-15 Year -10 U.S. Inflation Rate (%) 1919- 1925 1931- 1937 1943 1949 1955 1961 1967 1973 1979 1985 1991 1997 2003 2009 2
Posted: Fri Jul 01, 2022 8:12 am
- 15 Year 10 U S Inflation Rate 1919 1925 1931 1937 1943 1949 1955 1961 1967 1973 1979 1985 1991 1997 2003 2009 2 1 (26.17 KiB) Viewed 49 times
- 15 Year 10 U S Inflation Rate 1919 1925 1931 1937 1943 1949 1955 1961 1967 1973 1979 1985 1991 1997 2003 2009 2 2 (108.64 KiB) Viewed 49 times
- 15 Year 10 U S Inflation Rate 1919 1925 1931 1937 1943 1949 1955 1961 1967 1973 1979 1985 1991 1997 2003 2009 2 3 (72.26 KiB) Viewed 49 times
- 15 Year 10 U S Inflation Rate 1919 1925 1931 1937 1943 1949 1955 1961 1967 1973 1979 1985 1991 1997 2003 2009 2 4 (65.74 KiB) Viewed 49 times
-15 Year -10 U.S. Inflation Rate (%) 1919- 1925 1931- 1937 1943 1949 1955 1961 1967 1973 1979 1985 1991 1997 2003 2009 2015 2018 10 15 20
For this project, you will use the data set "College Data Fall 2020" which is an Excel data file that you can find on our D2L page. The data set contains data gathered from N=197 colleges and universities. Several variables were measured and are described as follows: I State: the state/district in which the school is located. Coded as: 1= Delaware; 2= District of Columbia; 3= Maryland; 4 = Pennsylvania; 5 = Virginia; 6 = West Virginia Location: the school is located in a City (1), Town (2), Suburb (3), or is Rural (4) Private/Public: the school is Private (1) or Public (2) Admissions Rate SAT Reading (75%): the SAT Reading score that falls at the 75 percentile SAT Math (75%) : the SAT Math score that falls at the 75 percentile Tuition & Fees Average Financial Aid Enrollment: this is the total enrollment (undergraduate + graduate) Undergraduate enrollment: this is just the number of undergraduate students enrolled Student-Teacher Ratio Graduation Rate (5-year) 15 16 In the Excel workbook, you will see multiple worksheets (the tabs at the bottom of your screen). Tab 1: "MASTER DATA FILE" The master spreadsheet containing all of the data. Tab 2: "Public vs. Private"-I isolated the Admissions Rates and Graduation Rates for Public versus Private schools for you; these are ready for your analyses in question #2. Tab 3: "Tuition by Location"-1 isolated tuition & fees by location (City, Town, Suburb, or Rural) for you; these are ready for your analyses in question #4. -
Use Excel to answer the following questions. Please be sure that all work that you turn in for a grade is your own. This assignment is worth a total of 100 points. You need to type/write your answer to each of the following questions AND provide all of your work in Excel to back up your answers. (For questions that require a graph, you don't need to draw out the graph-your Excel by itself is sufficient). If you would like to copy and paste from Excel into this document, you may, or you may upload your Excel workbook into D2L separately from this document. **Note: Every time your results open in a new worksheet, name that worksheet so you and I both know what's what.** 1. Analyzing Location. The variable Location is coded in the following way: 1 = City, 2 = Town, 3 Suburb, and 4 = Rural a. Create a frequency graph (either histogram or bar graph-you decide which is more appropriate) for the variable Location. b. What is the best measure to use to understand the central tendency of Location? Why? (hint: think about which measure of central tendency works best for the type of data you have here) c. Are there other measures of central tendency that you could use for this variable? Why or why not? d. Use Excel to determine the most typical location of the colleges/universities studied. Report it here and show your Excel results.
€155 XV versity Nesley College Delaware State University niversity of Delaware merican University atholic University of America Corcoran College of Art and Design laudet University Jeorge Washington University 10 Jeorgetown University 11 Noward University 12 ohns Hopkins University 13 eyela University Maryland 14 Aaryland Institute College of Art 15 otre Dame of Maryland University 16 Vashington College 17 Aunt St Mary's University 18 appin State University 19 Argan State University fx 3 A 20 sen University 21 iversity of Maryland Eaters Shore 22 lewe State University 23 reburg State University 24 bury! wity 21iversity of Maryland-Smare County 24versity of Maryland College Park 21 Mary's College of Maryland 28 Wright College 39 Uvenia erity 30 aw University 31 aage Man University 32 real University 3 34 ne University University y my versty Salle University 37 high University ying Calleg Arend University y Unity 43 ore College of Art and Design Ablebee Colle 40 ← MASTER DATAFILE 3 D State Location Private/Public Admissions Rate 1 1 1 2 2 2 2 2 2 2 3 Public vs. Private E 1 3 4 4 4 4 4 4 4 4 4 4 1 1 1 3 1 1 1 41 1 1 1 1 1 1 1 1 2 2 2 1 1 1 11 2 1 2 2 2 2 1 1 1 1 1 Tuition by Location 1 1 1 2 2 1 50 50 55 53 65 63 35 55 48 75 70 21 33 70 70 76 67 20 43 99 54 30 54 43 30 38 70 as 61 42 27 69 32 20 54 19 20 61 AS TERREST eck for Updates. SAT Reading (75%) 470 470 650 700 610 610 465 069 640 730 750 580 730 099 DES 630 600 370 310 340 680 540 360 580 580 670 580 630 590 460 490 540 470 480 540 600 640 680 680 570 330 SAT Math (75%) 620 670 710 059 300 550 540 780 680 610 580 500 480 480 540 550 720 580 570 590 530 680 470 470 660 670 019 540 440 700 750 570 770 059 620 560 610 580 460 490 590 Tuition & Fees 21565 7056 11192 37470 29700 38542 31536 5732 38071 35460 30140 11986 44148 41393 20171 42280 40870 6928 7906 6482 6147 7128 7332 9467 8655 14445 33990 26610 POSEZ 44010 34505 26671 25522 24640 35240 40960 31818 28175 27657 31478 39913 Average Financial Aid 20872 27928 ESTSE 7232 6804 18058 12874 18324 23232 14081 14569 16769 14584 21138 18456 15202 PHLE 17380 7284 8148 6678 7636 20525 15348 16586 16449 27832 29964 13356 29595 24340 14225 19642 20144 7407 7602 7903 4172 7460 3312 7222 Enrollment 3394 4143 11531 24860 9933 4076 3184 6685 7055 1366 1926 1992 2391 3011 9962 1931 4154 21489 12724 6894 4509 5608 5429 8606 13199 37633 1546 25260 17130 10583 20996 2253 2929 1553 2305 3813 8018 21464 0909 969