Open an Excel file named "Height and-Weight.xsx". This file contains the athlete information of certain Olympic athletes from a recent Olympik Games. This file contains the athiete 1D, the height of the athlete in centimeters, the weight of the athlete in kilograms, the country, and the gender of the athlete. We are interested n studying the relationship between the two varables er.d-wer. Remember we plotted the scater plot in the class, which was a plot for all athletes irnespective of the gender. Plot a similar scatter chart by segregating all the male athletes, the female athletes, and check whether similar patterns are observed across both genders. Question 2 (10+10+ 10+10+10 50 points) for this exercise, open the data file called Hw2 Dataset1.xisx. This file contains two main tabs. The first tab in the file contains the data. The second tab contains a description of the variables in the data set 1 Plot a Column or Bar Chart for math and write scores in one figure 2. Plot a Histogram of math scores for the students 3. What is the mean, min, max, sum, and count of math scores for students across this set which their math score is above of 3107 4. Highlight the grade of students which their math score is above of 310 pHint: using conditional fitering) S. Calculate the mean, sum, count, min, and max of math scones for Female students Open a file named "Car.txt.This dataset was taken from the Statub lbrary which is maintained at Carnegie Mellon University. The dataset was used in the 1983 American statistical Association Exposition The data contains city-cycle fuel consamption in miles per gallon (Quinian, 1993) The number of Instances are 398 and the number of Attributes ane 9 including the class attribute. The attribute Information (columns) are 1. mpg continuous 2. cylinders multi-valued discrete 5 weight: continuous 7 model year: multi-valued discrete 8 originc mulied discrete 9. car name string (unique for each instancel First insert this data into Excel and plot the scatter chart for MPG versus Wright for cars. Please answer to the following questions 1. ts there any relationship between these variables? If yes, please deteenne whether the relationship is positive or negative? 2. Add a Trendline to this data and an equation on the plot 3. R-squared is one of the main performance metric to evaluate the gpodness of a fit. The higher R squared is, the better fit you will get. Rased on R-squared, identifly which hyperplane is a best fit to the data, linear or non inear curves (i.e. Exponential Loganithmic, etc J? Open an Excel file named "Height and-Weight.xsx". This file contains the athlete information of certain Olympic athletes from a recent Olympik Games. This file contains the athiete 1D, the height of the athlete in centimeters, the weight of the athlete in kilograms, the country, and the gender of the athlete. We are interested n studying the relationship between the two varables er.d-wer. Remember we plotted the scater plot in the class, which was a plot for all athletes irnespective of the gender. Plot a similar scatter chart by segregating all the male athletes, the female athletes, and check whether similar patterns are observed across both genders. Question 2 (10+10+ 10+10+10 50 points) for this exercise, open the data file called Hw2 Dataset1.xisx. This file contains two main tabs. The first tab in the file contains the data. The second tab contains a description of the variables in the data set 1 Plot a Column or Bar Chart for math and write scores in one figure 2. Plot a Histogram of math scores for the students 3. What is the mean, min, max, sum, and count of math scores for students across this set which their math score is above of 3107 4. Highlight the grade of students which their math score is above of 310 pHint: using conditional fitering) S. Calculate the mean, sum, count, min, and max of math scones for Female students Open a file named "Car.txt.This dataset was taken from the Statub lbrary which is maintained at Carnegie Mellon University. The dataset was used in the 1983 American statistical Association Exposition The data contains city-cycle fuel consamption in miles per gallon (Quinian, 1993) The number of Instances are 398 and the number of Attributes ane 9 including the class attribute. The attribute Information (columns) are 1. mpg continuous 2. cylinders multi-valued discrete 5 weight: continuous 7 model year: multi-valued discrete 8 originc mulied discrete 9. car name string (unique for each instancel First insert this data into Excel and plot the scatter chart for MPG versus Wright for cars. Please answer to the following questions 1. ts there any relationship between these variables? If yes, please deteenne whether the relationship is positive or negative? 2. Add a Trendline to this data and an equation on the plot 3. R-squared is one of the main performance metric to evaluate the gpodness of a fit. The higher R squared is, the better fit you will get. Rased on R-squared, identifly which hyperplane is a best fit to the data, linear or non inear curves (i.e. Exponential Loganithmic, etc J
