please i need help solving provide calculation used

Problem 2: Gym Satisfaction Problem Details In an effort to evaluate its programming and services, a major fitness center surveyed its customers and requested Age (in years), Gender (1 = Male, 2 = Female), and Number of visits per week. In addition, the survey asked for ranking (1-5; lowest to highest) of satisfaction on Weights & Exercise Equipment, Club Staff, Exercise Programs, and Overall Service. The responses from 1,214 customers are provided in the Excel sheet titled, "Part Il Gym Satisfaction" in the file Group Case #1 Data. Of particular interest is whether more than 60% of the customers who express overall service satisfaction with the club (represented by codes 4 andS) are female. If this is not the case, the promotions director feels she must initiate new exercise programs that are designed specifically for women. Requirements (See rubric on page 7) Use the provided data to help the fitness center determine if new exercise programs designed specifically for women should be initiated In addition, considering the data provided, propose two additional interesting questions that the fitness center might be able to answer. Present the questions in words. Represent the questions as formal hypotheses. Club Staff Satisfaction 2 1 4 Weights & Exercise Equipment Satisfaction 1 3 2 2 4 2 2 3 3 1 2 2 3 1 2 4 Exercise Programs Satisfaction 1 3 1 2 2 2 3 1 2 2 1 2 1 1 2 3 Overall Service Satisfaction 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 3 2 4 3 2 2 1 3 2 2 2 2 1 3 3 4 2 2 2 3 2 4 1 1 3 4 4 3 4 4 Years With the Club 55 2 1 2 35 $ 2.5 3 3 4 55 2 25 4 1.5 3 35 1.3 4 2 1 2 25 2 1 1 3.5 25 3 13 1 25 2 2 2 3 2 2 2 2 2 2 2 2 2 2 2 2 1 2 1 1 1 4 1 2 3 3 1 3 2 2 2 5 2 1 1 2 2 2 2 2 4 3 1 2018