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 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

For this week’s discussion, you will examine what advocacy is

  For this week’s discussion, you will examine what advocacy is and then explore an advocacy organization in your community. As a human service professional, a key component of your role will entail connecting clients with community resources. For this reason, it is imperative that you are aware of the

Auditing – Robbins Network Services (RNS) in either Excel or Word

 Overview: Careful planning is a critical part of the success of every audit. However, planning is not simply done at the beginning of the audit but is a continuous and iterative process in which the results of one stage of the audit often necessitate revisions to plans for the next

Discussion 10-1 Max Kolesar posted May 24, 2022 5:08 PM

Discussion 10-1 Max Kolesar posted May 24, 2022 5:08 PM Read the article Balanced Scorecard Basics before participating in the discussion. An interesting case of the balanced scorecard used in the public sector is found in the article Applying the Balanced Scorecard Methodology in the Public Sector: The Case of

Instructions Identify a task that you would need to perform

Instructions Identify a task that you would need to perform in your current or future career, and explain how you would apply the knowledge you have learned in this course to succeed at performing the task in a real-world scenario. Your journal entry must be at least 200 words in

write a 4-page report in which you: Describe the specific

   write a 4-page report in which you: Describe the specific technology for protecting and gathering evidence Explain how the technology has influenced the criminal justice system Discuss any arguments in favor of or against this technology Explain any ethical dilemmas the technology may pose Conclude with how you think

After studying Module 1: Lecture Materials & Resources, discuss the

  After studying Module 1: Lecture Materials & Resources, discuss the following:  What strategies can staff nurses use to share evidence that could impact health policy decisions?  Initial post should be at least 500 words, formatted and cited in current APA style with support from at least 2 academic sources.  

Urinary Function: Mr. J.R. is a 73-year-old man, who was

  Urinary Function:Mr. J.R. is a 73-year-old man, who was admitted to the hospital with clinical manifestations of gastroenteritis and possible renal injury. The patient’s chief complaints are fever, nausea with vomiting and diarrhea for 48 hours, weakness, dizziness, and a bothersome metallic taste in the mouth. The patient is

Explain the implications of globalization. Identify at least two ethical

Explain the implications of globalization. Identify at least two ethical issues that go along with the global societal topic you have chosen for your final paper Explain how globalization contributes to or affects these ethical dilemmas. Propose solutions to these ethical dilemmas that are feasible financially, socially, and culturally.

Refer to at least three of the learning resources for

  Refer to at least three of the learning resources for the week in your response to one or more of the questions below. Include specific examples from your life, history, the news, or the media. · Why do legal protections for women’s employment rights continue to be an issue?

Assignment: Psychology of Personality Research and Well-Being Research Matrix Research

Assignment: Psychology of Personality Research and Well-Being Research Matrix Research is a critical component of the foundation of psychological theory in general, and certainly has been critical in the development of theories of personality. When consuming research about a research topic, it is important to understand basic aspects of psychological

In at least 2 pages, describe the mission of your

In at least 2 pages, describe the mission of your organization (e.g., what product or service is provided, to what intended markets, and how the product or service is distinct from those offered by competitors), who your customers are (internal and external), what value you add to the organization (how

This 3-4 page Project Assignment picks up the discussion of

   This 3-4 page Project Assignment picks up the discussion of the self in the week 2 discussion by asking you to further explore the question of who you are. If any of the philosophers we read this session might agree with your view, identify the philosopher and explain their

Latin American

Task: Choose one of the two prompts below to develop Essay 1. The essay should be 3-4 pages in length, double spaced, and in Times New Roman, size 12 font. A good paper will have a clear thesis statement in the introduction, and body paragraphs with clear topic sentences and

Values Statement

 The CEO of Acme Airlines, Wile E. Coyote, liked your Mission statement so well that he is now asking you to develop the Values statement for the organization. 1. Come up with a Values statement for Acme Airlines, your Values statement should: 2. Specify at least five (5) specific core

Smith’s Home Hardware is a successful Arizona – based retail

   Smith’s Home Hardware is a successful Arizona – based retail operation, realizing significant profits from its retail hardware stores. Smith’s creates a subsidiary (“Alixco”) by contributing $70 million of capital. The contribution of capital includes: $15 million of inventory, $15 million of CD’s, a $10 million office building in