Lab1_Khoury

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)

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)

5. Create Line chart (one chart that shows all three relationships – one chart with three straight lines) to show how prices of homes with different Cost per Sq Ft. changes by the size of the house (Square Feet). The graph will have three straight lines and should be able to help you compare the trends in prices by Sq. Ft for different Cost homes. Hint : Choose Square Feet for X-axis, Price for Y-axis, & Cost for Overlay. Save Scripts to Data Table. Name the script as Q5. Copy & paste your chart below and answer the following questions. (4 points total) i. The relationship between Prices and Square Feet is not the same (increases at the same rate) for all three Cost types. (1 point) A. True B. False ii. Prices of Low Cost homes increases at a much lower rate than Prices of Medium Cost homes as the size of the homes increases. (1 point) A. True B. False iii. Save the script to Data Table as Q5 (1 point) iv. Copy and paste the graph here. (1 points) 6. Create a table such that each row indicates City and columns (three) indicates mean Price by Cost Type. Hint : Use Analyze/Tabulate and drag the variables to Columns (Cost Type) and Rows (City), body of the Table (Price). Save Scripts to Data Table. Name the script as Q6. Copy & paste few rows of the table below and answer the following questions. (6 points total)

i. The mean price of a medium cost house in Canton is $ 209,090. (1 point) A. True B. False ii. Berea has no High priced homes, in the given data. (1 point) A. True B. False iii. Indicate all statements that are true. (2 points) A. Mean price of high-priced houses in Solon, rounded off to 0 decimal places, is $ 602,274. B. The mean price of a low-priced home in Mayfield heights is $ 192500. C. There are no medium- and high-priced houses in Maple heights. D. Average price of medium-priced Cuyahoga Falls is $ 124,397. iv. Save the script to Data Table as Q6 (1 point) Copy and paste few rows of the table, clearly showing the row and column headers. (1 points) Tabulate COST LOW MEDIU M HIGH PRICE PRICE PRICE CITY Mean Mean Mean Akron 119573. 4 248799. 4 609541.6 Alliance 124255. 6 202090. 0 486895.4 Amherst 204059. 0 232882. 3 237191.3 Ashtabula 224533. 3 183190. 0 114825.0 Aurora 318360. 0 380444. 4 582203.7 Avon 319900. 0 345387. 7 476028.9

0.5% 29900 0.0% minimum 4900 Summary Statistics Mean 284048.48 Std Dev 250647.56 Std Err Mean 4144.7753 Upper 95% Mean 292174.78 Lower 95% Mean 275922.17 N 3657 N Missing 0 BEDS 0 2 4 6 8 10 Quantiles 100.0 % maximu m 10 99.5% 6 97.5% 5 90.0% 4 75.0% quartile 4 50.0% median 3 25.0% quartile 3 10.0% 2 2.5% 2 0.5% 1 0.0% minimum 0 Summary Statistics Mean 3.4083665 Std Dev 0.9132253 Std Err Mean 0.0151013 Upper 95% Mean 3.4379744 Lower 95% 3.3787586

Mean N 3657 N Missing 0 SQUARE FEET 0 5000 10000 15000 20000 Quantiles 100.0 % maximu m 21000 99.5% 10007.1 97.5% 6657.926218 3 90.0% 4601.8 75.0% quartile 3180.5 50.0% median 2296 25.0% quartile 1665 10.0% 1224.8 2.5% 915.15 0.5% 650.6796719 9 0.0% minimum 320.4533487 Summary Statistics Mean 2674.8122 Std Dev 1602.8291 Std Err Mean 26.504813 Upper 95% Mean 2726.7779 Lower 95% Mean 2622.8465 N 3657 N Missing 0

Note:  Make sure all seven scripts are saved in the JMP Data file with appropriate labels.  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”)  Upload the JMP and word files on Brightspace under the Dropbox for “Lab 1”.