Can someone complete by deadline

iLAB OVERVIEW

Get a plagiarism free copy of this essay from our experts
Can someone complete by deadline
For as low as $13/Page
Order Now

Scenario/Summary

You are an intern with the Regional Realty Association and are analyzing the claim made by Alice Barr Realty that “we get your price.” You have prepared a spreadsheet that shows data relating to 3 months’ sales by Alice Barr Realty. You are going to determine the percent of asking price for each home sold and analyze the sales data to determine the true track record of the company in selling homes for the asking price.

Deliverables

Turn in one workbook titled lab3_yourlastname to the Dropbox. When submitting the workbook, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

iLAB STEPS

STEP 1: Open, Save, and Document the Workbook (5 points)

Back to Top

You must open a workbook that lists home sales for 3 months.

  1. Download the file chap4_cap_barr from DocSharing, Lab Materials.

  2. Open the workbook in Excel, and save it as Lab3_Yourlastname.xlsx.

  3. Insert a documentation sheet that includes title, author, date, and purpose. Format it appropriately, including changing the Sheet Name to Documentation. At the end of this activity, you will be asked to provide a conclusion as to whether this realty company “really gets your price.”

How to use the lab videos

Please do not rely solely on the videos to complete this week’s lab. The videos may not exactly match the official lab instructions, and may not show all the steps required.

For full credit, follow the written instructions on the main iLab page and the linked Step by Step guides. Check your work against the screen shots in the written instructions and the Lab and Project Grading Criteria provided in Doc Sharing. The videos can still help you, by showing operations that are similar to but not exactly the same as those needed for the lab. Use the videos as a rough visual guide, but not as your only source of directions.

If you have any questions, please post in the Q & A Forum or contact your instructor.

STEP 2: Add Calculations and Format Sales Data Worksheet (10 points)

Back to Top

A formula is used to calculate the percent of asking price, and this formula is applied to all listed sales. You will format the list in an attractive and useful manner.

  1. Calculate the percent of asking price for each sale (selling price divided by asking price). Enter the formula in Column F. Format Column F as a percentage with one decimal.

  2. Format Columns D and E as currency, with no decimals. Format Columns G and H as dates so just the day and month (for example, 5-May) are visible. You will need to use the Number Format dropdown list, select More Number Formats, and select the Date category.

  3. Widen columns to make all data and headings visible. Format titles as appropriate. Bold and center the column headings.

Your Sales Data worksheet will look something like this:

https://devry.equella.ecollege.com/file/669eb821-0322-49c0-b91d-e9d5e077fcd2/1/images--wk3%20ilab%20a.jpg

Lab 3, Step 2 Videohttps://devry.equella.ecollege.com/file/669eb821-0322-49c0-b91d-e9d5e077fcd2/1/images--Lab1.jpg

This video walks through the current steps in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step by Step guides.

** Please be patient when loading these videos because they can be large.

 

STEP 3: Sort Data and Create Summary Report and Chart (10 points)

Back to Top

  1. Before analyzing data, it is a good idea to copy the data to a new worksheet so that you have a back-up copy of the original data. Right click on the Sales Data sheet tab and select Move or Copy. Create a copy of the current spreadsheet and move it to the end. Name the sheet Sorted Data.

Download the Lab 3, Step 3 Instructions.

Lab 3, Step 3A Videohttps://devry.equella.ecollege.com/file/669eb821-0322-49c0-b91d-e9d5e077fcd2/1/images--Lab1.jpg

This video walks through the current step(s) in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step-by-Step guides.

** Please be patient when loading these videos as they can be large.

 

  1. In order to sort the data, you must convert them to a data table. Format the data table to look attractive.

  2. Sort the data by selling agent (A to Z) and then by asking price (largest to smallest).

  3. Convert the sorted data back into a range, and create a summary report showing the total asking price and total selling price by selling agent.

Lab 3, Step 3D Videohttps://devry.equella.ecollege.com/file/669eb821-0322-49c0-b91d-e9d5e077fcd2/1/images--Lab1.jpg

This video walks through the current steps in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step by Step guides.

** Please be patient when loading these videos because they can be large.

 

  1. Create a column chart that shows the difference by agent between asking price and selling price.

STEP 4: Filter the Data (5 points)

Back to Top

Download the Lab 3, Step 4 Instructions.

  1. Create another copy of the original sales data. Rename the sheet Filtered Data.

  2. Convert the range to a table, and then filter to show only those properties sold in Miami by agent Carey.

Lab 3, Step 4 Videohttps://devry.equella.ecollege.com/file/669eb821-0322-49c0-b91d-e9d5e077fcd2/1/images--Lab1.jpg

This video walks through the current steps in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step by Step guides.

** Please be patient when loading these videos because they can be large.

STEP 5: Apply Conditional Formatting (5 points)

Back to Top

You determine that one measure of how well the company “gets your price” is to set a scale. Excellent performance is at or above the asking price. Good performance is between 95% and 100%. Below 95% is average performance. You will create conditional formatting rules to display graphically the performance level for each sale. Make a copy of the original sales data chart. Name the new sheet Conditional Format.

Download the Lab 3, Step 5 Instructions.

  1. Select the data range and insert a table.

  2. Use Advanced Formatting to set up the following conditional formatting rules for the field Percent of Asking Price.

  • Use Percent of Asking Price as the Sort Key, and sort by color with green first, then yellow, and then red.

  • Lab 3, Step 5 Videohttps://devry.equella.ecollege.com/file/669eb821-0322-49c0-b91d-e9d5e077fcd2/1/images--Lab1.jpg

    This video walks through the current steps in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step by Step guides.

    ** Please be patient when loading these videos because they can be large.

    STEP 6: Create a Pivot Table (10 points)

    Back to Top

    Now that you have sorted, subtotaled, filtered, and conditionally formatted the data, you have a few more questions to answer. You want to see average percentage of selling price by agent and by city. This will allow you to see whether there are any patterns based on the city or based on the salesperson. To do this kind of comparison, you decide to create a pivot table.

    Download the Lab 3, Step 6 Instructions.

    1. Open the Sales Data worksheet. Select the Sales Data range (A3:H33). From the Formulas tab, select Define Name from the Defined Names group. Name the range of cells SalesData.

    2. Create a pivot table based on the named range, SalesData. Create the pivot table in a new worksheet.

    3. Select Selling Agent as your Row Labels and City as your Column Labels. Select Percent of Sales as your Values. Change the Summary type for Percent of Sales to average, the Number Format to percent, and the Name to Average Percent of Asking Price. Apply Data Bars Conditional Formatting to the percentages. Hide the Field Headers.

    4. Rename the sheet PivotTable, and move it so that it is the last tab in the worksheet.

    Lab 3, Step 6 Videohttps://devry.equella.ecollege.com/file/669eb821-0322-49c0-b91d-e9d5e077fcd2/1/images--Lab1.jpg

    This video walks through the current steps in this week’s Lab. The video may provide alternative ways of completing steps and may not cover all required steps. It is provided as a tool to help you, but please ensure that you have completed all steps as described in the instructions and Step by Step guides.

    ** Please be patient when loading these videos because they can be large.

    STEP 7: Draw a Conclusion (5 points)

    Back to Top

    On the Documentation Sheet, add a section called Analysis. Based on your data analysis, do you believe that Barr Realty should be allowed to advertise that they “Get your price?” Justify your answer by referring to the data analysis you have just completed.

    Submit your completed workbook to the Dropbox. Make sure you post a comment about what you learned when submitting the file.

     

    Place your order
    (550 words)

    Approximate price: $22

    Calculate the price of your order

    550 words
    We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
    Total price:
    $26
    The price is based on these factors:
    Academic level
    Number of pages
    Urgency
    Basic features
    • Free title page and bibliography
    • Unlimited revisions
    • Plagiarism-free guarantee
    • Money-back guarantee
    • 24/7 support
    On-demand options
    • Writer’s samples
    • Part-by-part delivery
    • Overnight delivery
    • Copies of used sources
    • Expert Proofreading
    Paper format
    • 275 words per page
    • 12 pt Arial/Times New Roman
    • Double line spacing
    • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

    Our guarantees

    Delivering a high-quality product at a reasonable price is not enough anymore.
    That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

    Money-back guarantee

    You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

    Read more

    Zero-plagiarism guarantee

    Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

    Read more

    Free-revision policy

    Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

    Read more

    Privacy policy

    Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

    Read more

    Fair-cooperation guarantee

    By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

    Read more

    Order your essay today and save 15% with the discount code VACCINE