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

April 18, 2024

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

>Business & Finance homework help

Share This Post

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

Related Questions

What is your experience with organizational conflict, whether as an employee or as a supervisor? What do you plan to accomplish in the next five to eight

What is your experience with organizational conflict, whether as an employee or as a supervisor? What do you plan to accomplish in the next five to eight years? Next, having read Chapter 1 in the textbook, as well as the Garden Depot case study, address the following in your initial

NR565 WK 6 Asthma

NR565 WK 6 Asthma 2 Asthma Treatment Algorithm: To successfully treat asthma, you must first classify it and then be familiar with step therapy. For this assignment and in this course, we will focus on patients 12 years and older. Complete the blanks in the following table to create an

MAIN OBJECTIVE OF TERM PAPER 1) Explore in-depth your interest in Gerontology; 2) Demonstrate expertise in that specific area in Gerontology. Ask a

MAIN OBJECTIVE OF TERM PAPER 1) Explore in-depth your interest in Gerontology; 2) Demonstrate expertise in that specific area in Gerontology. Ask a question that pertains to Gerontology, then provide “an answer” using empirical results from professional publications. Peer-reviewed literature from other scientific domains may be used (e.g., developmental psychology,

Evidence-Based Practice Paper regarding RhoGAM. Define evidence-based practice and describe the benefits of use in such evidence-based practice that was

Evidence-Based Practice Paper regarding RhoGAM. Define evidence-based practice and describe the benefits of use in such evidence-based practice that was witnessed. Include clear and specific details

I need help Imagine you have been asked by your school principal to develop a video on your research on healthy brain development in

I need help Imagine you have been asked by your school principal to develop a video on your research on healthy brain development in school-aged children that can be used by your colleagues at your school. Develop a 3-minute video that explains healthy brain development for your peers. Include the

AVIA 245 Page 1 of 2 SERVICE PROJECT PRESENTATION ASSIGNMENT INSTRUCTIONS This is part 3 of a three-part assignment: • Part 1 – Service Project

AVIA 245 Page 1 of 2 SERVICE PROJECT PRESENTATION ASSIGNMENT INSTRUCTIONS This is part 3 of a three-part assignment: • Part 1 – Service Project Plan – Module 3 • Part 2 – Implementation of Service Project – Module 4-6 • Part 3 – Service Project Presentation of Implementation –

Infographic For this formative, use the information from your Year In Review outline to create an infographic or other graphic artifact to visually

Infographic For this formative, use the information from your Year In Review outline to create an infographic or other graphic artifact to visually highlight the important areas in your review. As you develop your infographic, consider the following: ● What are the most salient parts of your ‘Year in Review’

Name: Enter your name here. Date: Enter the date here. Critical Thinking Final Touchstone In this assignment, you will make two contrasting normative

Name: Enter your name here. Date: Enter the date here. Critical Thinking Final Touchstone In this assignment, you will make two contrasting normative arguments about what one ought to do. Both arguments will be about the same topic, and so at least one of the arguments is likely to be

3 · NR505NP-10882 Week 7 Reflection on Learning Assignment Submit the reflection here before posting to the discussion thread.

3 · NR505NP-10882 Week 7 Reflection on Learning Assignment Submit the reflection here before posting to the discussion thread. Purpose The purpose of this assignment is to provide the student an opportunity to reflect on the weekly concepts learned in the course. IMPORTANT NOTE: Your instructor will be monitoring the Reflection on

Every artist has a person who they admire or take as a model for themselves – Everyone! No one creates in a vacuum. Who inspires you and why? Is your

Every artist has a person who they admire or take as a model for themselves – Everyone! No one creates in a vacuum. Who inspires you and why? Is your favorite artist a well-known person or an unknown? What kind of art do they make? What part of their art

I need you to complete a presentation on ‘Financial Decision Making.’ Here are the specific requirements: Complete a PowerPoint presentation

I need you to complete a presentation on ‘Financial Decision Making.’ Here are the specific requirements: Complete a PowerPoint presentation according to the requirements. Based on the PowerPoint, prepare a speech of approximately 15-20 minutes. Note: I have uploaded all the textbooks related to this course. I need you to

need work done on the PDF to complete and resubmit. The Excel file has the breakdown of marks for each section and instructions(notes) for what should be

need work done on the PDF to complete and resubmit. The Excel file has the breakdown of marks for each section and instructions(notes) for what should be added or changed. Please follow the instructions. Add any sources used to the reference list that’s already there. APA format

Explain Psychedelic-assisted therapy and discuss how it manualized psychotherapeutic treatment. Two scholarly source references are required.

THE IMPACT OF NURSING INFORMATICS ON PATIENT OUTCOMES AND PATIENT CARE EFFICIENCIES

Problem-Solution Week 8: Problem-Solution Presentation · Submitting a website url, a media recording, or a

Problem-Solution Week 8: Problem-Solution Presentation · Submitting a website url, a media recording, or a file upload · Available after Apr 13 at 11:59pm This week, you will prepare your written argument for oral delivery. Imagine you have submitted a proposal in written form, and your audience asks you

You must respond to two students who have chosen the other question. Always construct your responses in a word processing program like Word. Check for

You must respond to two students who have chosen the other question. Always construct your responses in a word processing program like Word. Check for grammar, spelling, and mechanical errors. Make the corrections and save the file to your computer. Find the posts that you are going to reply to. Submit your

Instructions – Apply the strategy below to the Internation Venture Idea (1 page)

Instructions – Apply the strategy below to the Internation Venture Idea (1 page) Strategy – Target the right strategy group strategy International Venture Idea – An education platform that can be accessed online by all students around the world implementing diverse languages and curriculum.

Sustainable Tourism Part III 1. Based on your previous findings and analysis, you need to present your recommendations on actions that the destination’s

Sustainable Tourism Part III 1. Based on your previous findings and analysis, you need to present your recommendations on actions that the destination’s tourism developers, managers, and marketers should take to improve the destination’s sustainability at the social, cultural, economic, and environmental levels and on advancing the sustainability of its