Place solutions in Excel and place each problem in it's own tab.For computational problems, please do NOT just list your final answer. Please show all work that was used to arrive at the final answer...

2-2.A study is being conducted in which a variable of interest has 1,000 observations. The minimum value in the data set is 300 points and the maximum is 2,900 points. Use the 2k = n guideline to determine the minimum number of classes to use in developing a grouped data frequency distribution. Based on the answer to part a, determine the class width that should be used (round up to the nearest 100 points). 2-19.The California Golf Association recently conducted a survey of its member. Among other questions, the members were asked to indicate the number of 18-holerounds that they played last year. Data for a sample of 294 members are provided in the data file called Golf Survey. Using the 2k = n guideline, what is the minimum number of classes that should be used to display these data in a grouped data frequency distribution? Referring to part a, what should the class width be, assuming you round the width up to the nearest integer? Referring to parts a and b, develop a grouped data frequency distribution for these golf data. Based on your answer to part c, construct and interpret a frequency histogram for the data. 2-22 .The manager of AJ’s Fitness Center, a full-service health and exercise club, recently conducted a survey was to determine the satisfaction level of his club’s customers. In addition, the survey asked for several demographic factors such as age and gender. The data from the survey asked for several demographic factors such as age and gender. The data from the survey are in a file called AJFitness. One of the key variables is “Overall Customer Satisfaction.” This variable is measured on an ordinal scale as follows: 5 = very satisfied 4 =satisfied 3 = neutral 2 = dissatisfied 1 = very dissatisfied Develop a frequency distribution for this variable and discuss the results. Develop a joint relative frequency distribution for the variables “Overall Customer Satisfaction” and “Typical Visits per week. 2-33.The first few years...