Project 2 InstructionsAs an Ivy Tech student, you are making an investment in your education. This project will look at how that investment will pay off if you graduate and get a job in your desired field. You will be comparing your future finances with s
Project 2 InstructionsAs an Ivy Tech student, you are making an investment in your education. This project will look at how that investment will pay off if you graduate and get a job in your desired field. You will be comparing your future finances with someone who is not a college graduate. Assume that the median annual income for a person who is only a high school graduate is $35,000 (although this may not be accurate for Indiana residents). Use this value in comparison statements with proper absolute and relative change statements.In this project you are required to do the following: Create an Excel spreadsheet to help calculate the correct values for housing and retirement. You must use Project 2 Excel template provided in the Project Module. Upload your Excel file inProject 2 where you will submit.Refer to the Excel help in the book or notes in the course on how to find mortgage or retirement values. You will use the PV, FV, PMT formulas in Excel as well as Excel multiplication (*), division(/), and subtraction(-) using cell references. See Project 2 Mrs. Vs Excel example in the Project Module. Your typed responses for this project will consist of answering short-answer questions given below. Each short-answer should be a minimum of 3 sentences and 50 words. Use proper quantitative reasoning and wording to address the solution. This should clearly convey your message to a reader who is not taking Math 123. Make sure to use your spreadsheet to answer what if questions with specific values and provide support for your statements. To do this, make changes in your spreadsheet and analyze the results of the manipulations be quantitative and specific with correct absolute and relative change statements. Your answers to these questions will be submitted in Project 2 where you will submit. HINT: As you are writing your absolute or relative change sentence, make sure to address more than or less than what value. Writing sentences such as, The absolute/relative change is… will NOT be counted as correct. What is the meaning of an absolute or relative change in each scenario?Examples of a poorly written responses:I can afford a $100,000 house. The relative change is 45.2He should take Option 1. The high school student should take Option 2.These responses are not good and will get a failing grade. They are vague and not quantitative. The responses do not indicate the student used their Excel spreadsheet, made the indicated changes, or analyzed the results. The responses do not meet minimum sentence or word count. Few specific numbers have been used which indicates the student is guessing at the correct answer without numerical evidence to show they have done the problem. We should not include the words “relative change” in a sentence, plus relative changes are percents! Examples of a well written responses will be given in class and are included in #5 below.Written response questions:1. Answer the two following questions related to your median annual salary and that of the high school graduate:Explain what job you have chosen and what has inspired you to pursue a career in that field. Use the median salary from the following website: https://www.bls.gov/oohHow does your salary compare to a high school graduate with an annual salary of $35,000 using BOTH an absolute change and relative change statement?
I have to have an excel done then you have to write a short essay about what u did