Lab1.docx | bartleby

JMP Lab 1: Data Visualization (40 points) Note: Use this Word document to complete your JMP Lab. Save the JMP file and this Word file using the following file naming convention: Lab1_YourLastName.jmp & Lab1_YourLastName.doc (Example: “Lab1_Mason.jmp” and “Lab1_Mason.doc”) (Please watch the JMP tutorials on Intro to JMP, Creating New Column using Formula, Local Data Filter, Data Cleansing & Visualization before starting on this lab) Name(s): Jawad Hoorani Purpose This lab is designed for you to demonstrate your understanding and ability to create appropriate charts and interpret the charts. After completing the tasks in this lab, you should be able to: 1. Create different types of graphs to answer questions. 2. Analyze graphs, interpret the results, and provide your insight. 3. Copy and paste charts from JMP output to this word document (use snipping tool) 4. Save scripts after creating every plot to the Data Table in JMP and save JMP file. 5. Save both Word and JMP files on your computer. 6. Rename files as indicated above. 7. Upload both JMP and Word files on to Brightspace for grading. Don’t upload it as a ZIP file . Always visualize your data before you try to do any data analysis. While creating charts, start with Graph Builder (Hint: Graph/Graph Builder). It’s a great way to visualize if there is something odd in your data (pattern or relationship that you did not expect), before you analyze. The power and flexibility of Graph Builder makes it a key tool for exploratory data analysis. The number of possible graphs for any given dataset can be overwhelming. You need to understand the structure of the dataset and the variables that form the basis of the questions you are trying to answer, which comes with experience. Use the Data file ‘Lab1_RealEstateData’ for this Data Visualization lab (see variables below).

There are 11 columns and 3,657 rows in the data file. Tasks Create the following four New Columns using the formula provided below. (4 points) 1. AGE = 2023-YEAR BUILT (1 point) 2. CONDITION = If AGE <= 20 Then CONDITION = “ NEW ” Else CONDITION = “ OLD ” (1 point) 3. PRICE/SQFT: PRICE/SQUARE FEET – format with a fixed decimal of 2 (1 point) 4. COST: (If PRICE/SQFT > 150 Then “ HIGH ” Else (If PRICE/SQFT < 75 Then “ LOW ”) Else “ MEDIUM ”) (1 point) 1. Create a Pie chart to find the proportion of each Property Type present in the data. Label the Pies with Percent of Total Values (Graph/Graph Builder). Save the Scripts to Data Table - Name the script as Q1 (indicating question #1); Copy & paste your chart below and answer the following questions. (4 points total) i. What percentage of houses are Single Family Residential type? (1 point) A. 18.2% B. 1.9% C. 79.8% is the answer D. 28.2% ii. Which Property Type has the lowest percentage of houses in this sample data? (1 point)

A. Multi-family (2-4 Unit), is the answer. B. Condo/Co-op C. Single Family Residential D. Townhouse iii. Save the script to Data Table as Q1 (1 point) Done iv. Copy and Paste the Pie chart with Label below. (1 point) 2. Create a Bar chart to compare the mean price of houses in the following cities: Copley, Hudson, Stow, Wadsworth and Warren (use the Local Data Filter feature on the field ‘CITY’ to select the Cities mentioned above – Hint: click on the red Triangle after creating bar graph and select the option Local Data Filter). Label the Bars by Values. Save Scripts to Data Table as Q2. Copy & paste your chart below and answer the following questions. (4 points total) i. What is the mean price of houses in Copley? (1 point) A. $ 332,825

B. $ 127,551 C. $ 282,212, is the answer. D. $ 456,789 ii. Which city has the lowest average price? (1 point) A. Hudson B. Stow C. Copley D. Wadsworth E. Warren, is the answer. iii. Save the script to Data Table as Q2 (1 point) iv. Copy and paste the chart below. (1 point)

3. Create a Scatter plot to explain the relationship between Price and Square Feet. Include line of fit (and points) in your chart (choose this from the Graph options). Save Scripts to Data Table. Name the script as Q3. Copy & paste your chart below and answer the following questions. (4 points) i. Which of the following statements is correct about the relationship between Price and Square Feet. (1 point) A. Price decreases with increase in Square Feet B. Price increases with increase in Square Feet, is the answer. C. Square Feet has no effect on Price

D. None of the above ii. If you decide to pay a lower Price, you can expect to buy a big house. Answer based on the graph. (1 point) A. True B. False, is the answer. C. No appropriate data to answer this question. iii. Save the script to Data Table as Q3 (1 point) iv. Copy and paste the chart here. (1 point) 4. Create a Line chart (one chart that shows all three relationships – one chart with three straight lines going from left to right without data points ) to show how prices of Condos/Co-ops, Multi-Family (2-4 Unit) houses and Single-Family houses changes over years (YEAR BUILT). The graph will have three straight lines and should be able to help you compare the trends in prices for each of the above-mentioned Property Types over time. Hint : Choose Year Built for X-axis, Price for Y-axis, & Property Type for Overlay. Save Scripts to Data Table. Name the script as Q4. Copy & paste your chart below and answer the following questions. (6 points total) i. Prices of all Property Types decrease over the years. (1 point) A. True, is the answer.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help