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

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.