MUST LOG INTO MY PEARSON ACCOUNT TO ACCESS TEXTBOOK!
Chapter 3: Problems 2, 4, 6, and 12
Appendix A3: Problem 4
The problems must be done by Excel and submitted in one Excel file. The Excel file of five sheets. Each sheet must be named the problem number as shown above.
The problems must be done in regular Excel and the actual Excel file to be submitted in canvas. No submission in google account or link to the cloud will be accepted.
The submission must be done in CANVAS to be graded. No submission by email will be graded. No late HW is accepted under any condition.
The data file has posted in CANVAS.
2.) Create a line chart showing the growth in the annual CPI in the Excel file Consumer Price Index.
4.) Create a pie chart showing the breakdown of occupations for each year in the Science and Engineering Jobs Excel file, and contrast these with simple column charts.
6.) A national homebuilder builds single-family homes and condominium-style townhouses. The Excel file House Salesprovides information on the selling price, lot cost, type of home, and region of the country (Midwest, South) for closings during one month. Construct a scatter diagram showing the relationship between sales price and lot cost. What conclusion can you reach?
12.) Construct an appropriate chart or charts to visualize the information in the Budget Forecasting Excel file. Explain why you chose the chart(s) you used.
A3.) Use PivotTables to find the number of loans by different purposes, marital status, and credit risk in the Excel file Credit Risk Data. Illustrate the results in a PivotChart.
