INFO10514 - Data Analysis Using Business Information Systems Assignment

Assignment Task

Introduction steps

Download the attached Excel data file.

In report create 4 sheets with the following names: Problem 1, Problem 2, Problem 3, Problem4.

The results of each Problem should be placed into the corresponding sheets.

Problem1. Property Analysis

Copy Property Data into Problem #1 sheet.

1. Sort the records in A-Z order using the property Type variable and simultaneously by Sq_ft variable in largest to smallest order.

At the bottom of the table for each numeric column add MIN, MAX, Average values. Don’t forget to add labels to identify these values.

For each property type pls highlight by color three of them on top and three of them at the bottom.

2. Copy the green table into Problem1 sheet and fill it by the help of Excel functions (not manually).

3. On the same sheet create two histograms of Price for 4 and 8 number of intervals (bins). Pay attention to label axes and chart titles.

What conclusion can be done based on the above histograms?

Problem2. Decision Matrix 

Suppose that you are planning to take a trip and you have five different destinations to choose from. The attractiveness of each destination (in the range from 0 up to 5) were rated by special company before.

• Copy the Decision Matrix template into Problem #2 sheet.
• By the help of Excel randomly assign weights to each criterion in the range from 0.2 to 1 .
• By the help of Excel randomly assign grades for each destination in the range from 0 to 5 
• Calculate scores for each destination.
• Explain which destination you will pick and why? Highlight by color the final answer.

Problem3. Employee Retirement & Health Plan (1%)

A company contributes to employees’ retirement plans at the rate of 4% of the employee’s annual salary. To be eligible for this benefit, an employee must have full-time status with two or more years of employment.

Write the Excel formula to calculate: 1) Retirement Contribution in $$ for each employee; 2) Health Plan Cost ($10K of annual coverage for employees who choose the family plan, and $8K for employee with individual plan) .

The best solution will be if you could use a single logical formula in each task. But there’s more than one way to do this as you know.

Problem4. SWOT Analysis

Provide SWOT Analysis for any one problem from the list. At least 4 factors should be used in each table segment.

Final steps

Before saving results please check that all charts have titles and axes names. Save your results in one report file: YourFirstname_YourFamilyname.xlsx Submit your report to the Dropbox before the Deadline.

Only in the case of Dropbox technical issues, submit your report to my Slate email.

This INFO10514 - Management has been solved by our PhD Experts at My Uni Paper.