### Our Services

Get 15% Discount on your First Order

# Open the HomePrices.xlsx text file in Tableau.  Drag the Home Prices Spreadsheet into the data connection canvas. Run interpreter.  Review the Excel file

Open the HomePrices.xlsx text file in Tableau.

Drag the Home Prices Spreadsheet into the data connection canvas.

Run interpreter.

Review the Excel file that Tableau generated. (Note that this dataset is formatted correctly)

Create a bar chart showing the distribution of building types:

• Click on Sheet 1
• Double-click on the Number of Records (or drag it onto the rows shelf). Note that the aggregation Sum(Number of Records) is placed on the Rows Shelf
• Drag Bldg Type to the Columns Shelf
• Question 1: What have you learned about the distribution of building types?  Which Building Type has the most homes for sale?  The least?

Create a histogram of Sale Price:

• Click on Sheet 2
• Double-click on Sale Price (or drag onto rows shelf)
• Select histogram in ShowMe
• Question 2: What field did Tableau create to make the histogram?  Why?
• Question 3:  What is the shape of the histogram?  Will the mean or median have a higher value?  Which value (mean or median) would be a better measure for the center of the distribution?

Create a boxplot of the Sale Price:

• Create new sheet
• Double-click on Sale Price (or drag onto rows shelf)
• Disaggregate measures (de-select “aggregate measures” in the Analysis menu)
• Select the box plot from the ShowMe menu
• Drag Bldg Type and House Style to Tooltip on the Marks card
• Question 4: Are there outliers present?  If yes, are outliers above or below the center of the distribution?
• Question 5: What house style has the highest sale price?

Create a set of box plots of Sale Price for Building Type:

• Duplicate the Boxplot of the Sale Price Sheet (right-click the tab and select duplicate from the dropdown menu)
• Drag Bldg Type to the Columns shelf
• Question 6:  Which building type has the lowest median Sale Price?
• Question 7:  Which building type has no outliers in Sale Price?
• Question 8:  Which distribution has the largest spread?  The smallest spread?

Part II: Scatter Plots and Regression

You are interested in determining what factors influence the house sale price (SalePrice). To investigate this question, do the following:

Construct three scatter plots.  For each plot, place the Explanatory variable on the x-axis and the Response variable on the y-axis.

Variable combinations:

• YearBuilt and SalePrice
• 1stFlrSF and SalePrice
• LotArea and SalePrice
• Question 9: Evaluate the regression conditions for each plot.  Explain why or why not it is appropriate to run a regression analysis on each plot.  Please address all conditions covered in this module (Hint: Slide 25 in the lecture notes).

For plots that meet the regression conditions, add a linear trend line.

Please submit your .twbx file + a screenshot of your notebook here and respond to the questions

Order a Similar Paper and get 15% Discount on your First Order

## Related Questions

### 1 Running head: [Shortened Title up to 50 Characters] 3 2 Complete Title Here – Up to 12 words on one or two lines- upper and lower case Student

1 Running head: [Shortened Title up to 50 Characters] 3 2 Complete Title Here – Up to 12 words on one or two lines- upper and lower case Student Name – First M. Last University Course number and Name Professor Date Complete Title Here – Up to 12 words on

### follow instructions QUESTION 1 (This is suppose to be a literature review) Describe the background information as an

follow instructions QUESTION 1 (This is suppose to be a literature review) Describe the background information as an introduction to the research problem and discuss the purpose of the study. Identify and discuss a theory which helps analyze and understand the problem. Evaluate the current state of the literature and

### Create an email update/follow template using the attached Executive Summary as a reference to send to companies 2 Executive Summary

Create an email update/follow template using the attached Executive Summary as a reference to send to companies 2 Executive Summary for the “I Spark Change: Comprehensive Project Plan.” Include a short statement to introduce our purpose. We seek to create the world’s first social impact – social media platform to

### Provide a vision and leadership strategy for “Southwest Transit” Details will be attached.

Provide a vision and leadership strategy for “Southwest Transit” Details will be attached.

### Create a Business Plan PowerPoint for a restaurant. There will be 4 different PowerPoints including, the Company Description, Ethics Plan, Marketing Plan

Create a Business Plan PowerPoint for a restaurant. There will be 4 different PowerPoints including, the Company Description, Ethics Plan, Marketing Plan, and Operational Plan PPTX.  All the instructions and templates are attached below.

### The Basics of Marketing Watch this week’s video: Using a product that you regularly purchase as the

The Basics of Marketing Watch this week’s video: Using a product that you regularly purchase as the example (Cannot use Tesla as the product), write a one-page summary that answers the following four questions. 1. Which customer market segments (groups) are being targeted? 2. How does the marketing of the

### This week, you will compare two major companies’ supplier requirements. For example, if you are interested in becoming a supplier review

This week, you will compare two major companies’ supplier requirements. For example, if you are interested in becoming a supplier review the  TargetLinks to an external site.  and  Wal-MartLinks to an external site.  Websites.   In a Word document, you will provide the following information for both suppliers: · Brief overview of

### Topic: Negligence, Product Liability, Property Law, and Intellectual Property This assignment should be written in APA style

Topic: Negligence, Product Liability, Property Law, and Intellectual Property This assignment should be written in APA style and should include: · Two pages in length (not including the title page and reference page) · Double-spaced · 12-point font

### Related calculation problems Page 2 of 5 ACCT42115-WE01 1. Maryam must select a decision from three alternatives, labelled 𝑎1, 𝑎2, 𝑎3.

Related calculation problems Page 2 of 5 ACCT42115-WE01 1. Maryam must select a decision from three alternatives, labelled 𝑎1, 𝑎2, 𝑎3. The outcome she receives depends on which of four equally likely states occurs. The states are denoted 𝑠1, 𝑠2, 𝑠3, 𝑠4. The table below presents the cash outcomes for

### Assignment Details While assisting the accounting department with completing the current year’s financial statements, you have been asked to review a

Assignment Details While assisting the accounting department with completing the current year’s financial statements, you have been asked to review a list of contingent liabilities. Explain how you, as a manager, would review the list of contingent liabilities and determine their probability. Discuss with your classmates other ways of

### Explain the differences between a group and team. Then, discuss the stages of group and team development as it applies to groups in your workplace. Be

Explain the differences between a group and team. Then, discuss the stages of group and team development as it applies to groups in your workplace. Be sure to focus your response on specific steps that you recommend to “unstick” the group’s development to the performing stage. Explain how the concept

### Reflect or think about an instance in which you have witnessed or experienced role conflict or team failure and the two types of ambiguity. State what

Reflect or think about an instance in which you have witnessed or experienced role conflict or team failure and the two types of ambiguity. State what happened and how you reduced the role conflict, addressed the team failure, or resolved the type of ambiguity.

### 1- Conduct a situation analysis (p. 66+) textbook citation in a, b, and c a. Macro level external environment (p

1- Conduct a situation analysis (p. 66+) textbook citation in a, b, and c a. Macro level external environment (p 67) Start here and double space…Give 2 examples how it affects your company b. Competitive environment (p. 68-pick 2) Start here and double space…Give 2 examples for your company c.

### see attached  Wk 2 – Apply: Summative Assessment: Agile Training Presentation Exam Content Top of Form Continuous

see attached  Wk 2 – Apply: Summative Assessment: Agile Training Presentation Exam Content Top of Form Continuous improvement is an important component of agile methodology. A skilled project manager needs to be able to identify existing tasks and apply different concepts to improve the project. Identify 1 project you are involved

### 5.2 Peer Review of Assessment Video: Respond to the following two video posts. The due date is Monday, May 20.

5.2 Peer Review of Assessment Video: Respond to the following two video posts. The due date is Monday, May 20. Joy: Jessica:

### they’re two parts for this final.  Lehman College MSC 220 – Introduction to Public Relations Spring Semester 2024 Final Examination – 100 points

they’re two parts for this final.  Lehman College MSC 220 – Introduction to Public Relations Spring Semester 2024 Final Examination – 100 points Due via email Word attachment and Turnitin by 11:59 p.m., Friday, May 17. This final examination is open book, open notes, open Blackboard, open Internet. You may

### ANNUAL PERFORMANCE REVIEW Complete the review as accurately as possible. 3-5 sentences, Fill out

ANNUAL PERFORMANCE REVIEW Complete the review as accurately as possible. 3-5 sentences, Fill out each value on how each employee showed these values. 1. Be Kind- A constant demonstration of compassion, patience and understanding. 2. Crush Obstacles- Finding ways to overcome challenges through resilience and creative thinking. 3. Develop and