Question

I need help with problems II (1-6), III (1-5)

MATH Assignment for Core Assessment, 2017-18 Job opportunity surveys have consistently shown a high demand for those who can use mathematics to model complex processes and make informed predictions of the future. With this assignment, the student has the opportunity to demonstrate his or her level of sophistication with respect to the key, in-demand skills of communication, quantitative literacy, and critical thinking. 0 One skill of critical thinking involves evaluating information taken from sources and questioning its authenticity. This assignment may contain questionable information. Objective: You are to consider the implications of rising tuition costs and make better, more informed life decisions with respect to course load. Specifically, you will estimate the tuition costs in the year 2019 - 2020 Answer the following questions using complete sentences. I. Visual Communication (the ability to recognize and understand ideas conveyed through visible images.) The attached set of images, “Are you on the Fast-Track?" is found on the Eastfield College website. Although figure numbers are not actually printed on the graphic, consider Figure 1 as being "Time Is Money". This particular image will not be used in this nt. Consider Figure 2 as relating the number of classes taken per semester to the time required to complete a degree. Consider Figu costs of tuition (the smooth solid (red) line with an arrow.) (Perhaps writing "Fig. 2" and "Fig 3" beside these images would be helpful.) re 3 as the COST graph, predicting 1. Description of the image For Figure 2, "Number of classes" and Figure 3, "Cost," identify the type of graph Choose one of the following: line graph, bar graph, picture graph, or pie (circle) graph a. Figure 2 is a ar aph b. Figure 3 is a 0. Bxplain how the choice of bobks and caps as icons in Figure 2 afet the image's now

Answer 1

1B 1 Year 2 2004-05 З 2005-06 4 2006-07 5 2007-08 6 2008-09 7 2009-10 8 2010-11 9 2011-12 10 2012-13 11 2013-14 12 2014-15 13 1A Difference Inflation 1738 1791 1885 1886 1800 1932 2030 2151 2232 2248 2286 356 1382 1469 1610 1649 1662 1746 1858 2040 2146 2204 2286 18%-D2/$D$ 13 17% 14% 12% 7% 10% 9% 5% 4% 2% 0% 275 237 138 186 172 86 0 1927 SUM(D2:D12) Sum

1.a. Cost of tuition and fees is increasing every year and the cost of tution and fees is less than the current year. With the current value of money, you will pay than the previous year. In 10 years back, it is 18% less than the current year 14 2014-15 151.b. because current value of the dollar is same for the year of taking the courses and paying the tuition and fees with current dollar will have the same purchasing power. Money value is decreasing in the next year by the rate of inflation. 16 If you plot the 1B data on 1A data using a scatter plot, you will get the 17 relationship equation of y-1.5025*1B-1179.3, On an average, every year going back delaying to get a degree, the predicted cost will increase 1.5025 times the actual cost 148

Tuition and fees 2400 y 15025x-1179.3 R2 0.9707 2200 2000 1800 1B 1600 -Linear (18) 1400 1200 1200 1400 1600 1800 2000 2200 2400 1B

19 За 20 b 21 1A Average cost for actual cost of 2 year degress Median of table 1A Sort the data from smallest to highest 1822.909 AVERAGE(C2:C12) 1932 MEDIAN(A22:A32) 1738 Count the number of data values 1791 (n+1)/2 1800 6th value is the median of the data set 1885 in five years, 50% of the costs are lesser than 1932 and 50% are higher than 1886 1932 from the fifth year to 10th year values 1932 2030 11 ECOUNT(A22:A32) 23 6 1932 25 26 27 28

1932 2030 2151 2232 2248 2286 28 29 32 33 C Mode of table 1A #N/A Cost is not same in any of the two years in the past ten years 35 36 d 37 1A 38 39 ROUND(A38,-1) 1738 1740 53 A39-A38 1791 1790 94

36 d 37 1A 38 39 40 ROUND(A38,-1) 1740 1790 1890 1890 1800 1930 2030 2150 2230 2250 2290 890 MODE (B38:B48) 53 A39-A38 1738 1791 1885 1886 1800 1932 2030 2151 2232 2248 2286 94 86 132 98 121 81 16 38 42 43 45 46 47 48 49 Mode $ 54.80 Average increase per year

50 Tuition and fees for a 2 year degree programme is same for the three years 2006-07,08,09 51 Sum 52 53 54 f $21,990.00 SUM(B38:B48) Total fees from 2004 to 2014 $ 1,999.09 FAVERAGE (B38:B48) 1B 56 1382 1469 1610 1649 1662 1746 1858 2040 87 -B57-B56 141 39 13 84 112 182 106 57 59 60 61 62 63

62 63 64 65 1858 2040 2146 182 106 82 2286 $ 90.40 Average increase per year 67 $20,052.00 SUM(B38:B48) $ 1,822.91 FAVERAGE (B38:B48) 69 70 9 71 10 times the average IA $ 548.0010 D48 1B $ 904.0010 D66