Scenario/Summary Summit Ridge Mountain Resorts has decided to expand. Because of the popularity of the resort among the business community and families, Summit Ridge has decided to purchase some apartments for guests and seasonal employees to have an extended stay. Because these will prove to be a long-term investment, Summit Ridge has decided to put all complexes on a remodeling rotation to ensure the apartments each have a modern and functional style. It is now your job to analyze the information regarding the apartments. The owners are looking for some specific information about rentals by apartment size (such as the number of bedrooms per apartment). Based on current housing interest rates, Summit Ridge is considering a sixth apartment complex and has asked you to perform some financial calculations and analyses to determine how adding this new complex to their portfolio enhances the resort’s financial position. They will then use this information to come up with a marketing plan to attract additional customers to the resort. Remember that you are making a professional analysis and presentation, so be sure to give some thought to what you are trying to recommend to the management of Summit Ridge and why. Deliverables After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week5_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week5_Lab.xlsx. Lab 5 – Mountain Statistical Analysis Step Task Points Possible Points Received Comments 1 Insert Functions 1a – b Insert nested function 7 2a Create a search 2a, b Insert nested lookup function 4 3 Manage Database List 3a, c Perform advanced filter and enter database functions 4 4 Loan Amortization 4a, c Insert functions, complete amortization table, and footer 8 5 Conditional Functions 5a, g Insert conditional functions, calculate total and average 8 6 Statistical Functions 6a-d Calculate rank, minimum, and remaining quartile 6 6e Calculate the correlation and format the data 6 7 Using the Analysis of ToolPak 7a-c Use Descriptive Analysis, complete input criteria, set out 6 7d, e Create histogram chart, use quartiles and format chart 6 Comment: What you learned from completing this Lab 5 TOTAL POINTS 60 0 Week 5 Grading Rubric Lab Resources Microsoft Office: Excel 2016 Options for Accessing Microsoft Excel 2016 Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources page. If you are a MAC user, click to read the MAC User Information . If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon. Lab Steps Preparation You will be using Microsoft Excel 2016 for this lab. Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab. Please do not rely solely on the hands-on exercise videos to complete this week’s lab. The videos provide detailed examples walking you through the hands-on exercises. Applying the hands-on exercise examples will provide both practice and instruction of what to complete. Begin: Open and Save Download the spreadsheet Week 5 Lab – Summit Ridge Mountain Resort Student.xslx. (Links to an external site.) Links to an external site. You will be prompted to save the file. Click yes. Open the saved file from your Download folder on your computer. Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources. To save the spreadsheet with a new file name, open the workbook in Excel 2016; and in Excel, click File, then Save as, and rename it as lastname_first initial_Week5_Lab.xlsx (Jane Doe would save the file as Doe_J_Week5_Lab.xlsx). St…

Looking for solution of this Assignment?


We deliver quality original papers

Our experts write quality original papers using academic databases.  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay