Lab1_Khoury.docx | bartleby

JMP Lab 1: Data Visualization (35 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_Johnson.jmp” and “Lab1_Johnson.doc”) (Please watch the JMP tutorials on Creating New Column using Formula, Local Data Filter & Visualization before starting on this lab) Name: ______Isabelle Khoury_____ 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 4. Save scripts after creating every plot to the Data Table in JMP 5. Save both Word and JMP files 6. Rename files as follows: Lab1_YourLastName.jmp & Lab1_YourLastName.doc 7. Upload both JMP and word files on to Brightspace for grading. Use the Data file ‘Lab1_RealEstateData’ for this Data Visualization lab. 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 points) 3. PRICE/SQFT: PRICE/SQUARE FEET – format with a fixed decimal of 2 (1 points) 4. COST: If PRICE/SQFT > 120 Then “ HIGH ” ELSE If PRICE/SQFT < 80 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. 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 Condo/co-op Property Type? (1 point) A. 18.2% B. 1.9% C. 79.8% 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) B. Condo/Co-op C. Single Family Residential D. Townhouse iii. Save the script to Data Table as Q1 (1 point) 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: Akron, Brecksville, Canton, Copley, Hudson, (use the Local Data Filter feature on the field ‘CITY’ to select the Cities mentioned above). Label the Bars by Value. 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 Brecksville? (1 point) A. $ 332,825 B. $ 127,551 C. $ 463,668 D. $ 456,789 ii. Which city has the highest average price? (1 point) A. Hudson B. Stow C. Copley D. Wadsworth iii. Save the script to Data Table as Q2 (1 point)

iv. Copy and paste the chart below. (1 point) Mean(PRICE) vs. CITY 0 100000 200000 300000 400000 500000 249868 463669 236098 282212 519560 Akron Brecksville Canton Copley Hudson CITY Mean 3. Create a Scatter plot to explain the relationship between Price and Square Feet. Include line of fit (and points) in your chart. 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 statement 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 C. Square Feet has no effect on Price D. None of the above ii. If you decide to buy a house with bigger area, you must be prepared to pay higher price. Answer based on the graph. (1 point) A. True B. False

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)

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