1. Use a appropriate excel function to obtain a frequency distribution for the variable age. Use Table 1 (blank tables start in Column F) to summarise the results. [2 marks] In preparation for the remaining questions, sort the data by age, and then transfer the Quality and Spend data corresponding to individuals under 35 to columns F and G, and the data corresponding to individuals 35 or older to columns | and J (as indicated by the column headings}. Be careful to do the sorting correcy, highlighting columns A through D before sorting. Otherwise, all your remaining work will be meaningless. 2. Obtain two percentage frequency distributions for the variable Quality: one for the age category Under 35 and the other for category 35 or over. Put your answers in Table 2. Explain briey why percentage frequency should be used here instead of frequency. [3 marks] 3. Use an appropriate chart to display the information from Table 2. [2 marks] 4. Briey discuss the relationship behveen age and attitude to quality as revealed in questions 2 and 3. [Write about a hundred words that help the reader interpret the results. It is unnecessary to repeat every percentage in the table, but pick out the aspects that highlight what seems to be going on here. Restrict your attention to the two age categories used in questions 2 and 3: do not go back to the original more detailed age categories for this discussion] [4 marks] 5. Provide a table of summary statistics (Table 3) for the variable Spend, separately for the under 35's, and the rest. [2 marks] 6. Construct a grouped percentage frequency distribution table (Table 4) for amount spend for each of the two age categories. [2 marks] 3'. Use the Table 4 to plot an appropriate graph for the two frequency distribution. [2 marks] [Questions 8, Q and 10 should total 350 to 450 words, and be based on the tables and graphs in questions 5, B and T] 3. Based from graph in part (7) discuss and compare the two distributions. [6 marks] 9. Discuss and compare the locations of the two distributions. [6 marks]