Hide Folder Information
Instructions
Business Applications Project As a graduate from Red River College, you are working as a consultant for Claw Construction. The owner is trying to decide whether to change business models to generate more revenue; the company primarily works on non-residential construction projects, but is interested in expanding into residential markets. How to Proceed Part 1 - Excel Your supervisor has asked you to research demand and profitability indicators to decide if this idea is worth considering. Is it more profitable to remain in non-residential construction, or are there missed opportunities in residential construction? Using the City of Winnipeg'sopen data website(use aggregate data), you will compare the frequency (#) and total value ($) of residential construction permits vs non-residential permits that have been issued in the following neighborhoods between the years 2015 to 2020: The Forks Tuxedo Waverley Heights West Broadway Transfer the relevant data into an Excel spreadsheet, and ensure you: Download the raw data into a separate worksheet and use your name_raw in the label Sort the relevant data using a structured table and format it into a table of your choice. Use accounting format with zero decimal places. Create properly formatted title and table elements on a separate worksheet with your name_table in the label. Insert at least one mathematical/statistical function(s) into the spreadsheet. Creat a chart or graph of your choice to help visualize your information on a separate worksheet with your name_graph in the label. Save as: Firstname_Lastname_Project.xlsx