To complete the assignment, first review and complete the attached Assignment One Sample and watch this video
tutorial. This spreadsheet works through a sample analysis, finding the relationship between personal consumption expenditures on financial services and insurance and disposable personal income. Next, download and open the attached Excel worksheet titled Excel Assignment One. In this assignment, you will be finding similar relationships for two other areas of consumer spending: motor vehicles and parts and housing and utilities. Place your answers in the Excel spreadsheet. Save your answers and give your spreadsheet a new name in the form, following this naming convention (use your last name and first initial): SmithCExcelAssgn1.