Please provide an answer as clearly as possible, answer the question as directions are given in the question.

Part B [Long Question: 30%} You are allowed to use a spreadsheet to solve this question. Please attach your spreadsheet file with your scanned solution le. Please use the spreadsheet le that accompanies this Assignment Question paper. The spreadsheet contains 2 tables: The Table on the left is a Table containing the parameters of Personality Types (Extraversion, Agreeableness, Conscientiousness, Neuroticism, Openness). The Table onthe right is a Table containing the parameters of Learning Style (Visual, Auditory, Readilii.r rite, Kinesthetic). \"Educational researchers are interested to nd out the link between the human personality to the human learning style. This is so that a personalised learning strategy can be formed for the different types of human personality." Assume the data are normally distributed and use the sample mean and standard deviation calculated from the data. Perform 3 hypothesis testings (twotailed, uppertailed, and lowertailed) on the mean between one parameter from each table at o = 0.01 (1% signicance level} by setting the appropriate null and alternative hypotheses. State the best conclusion for your hypothesis testings. By referring to the last 2 digits of your student 1]), refer to the following codes to select the columns for your data (parameters): Digit Extraversion 0, 9 Visual 0, 4 Agreeableness l, 8 Auditory l, 5 Neurotiein 3, 6 Kinesthetics 3, T Openness 4, 5 For example, if your 1D is 1001001191, you will select the column of Extraversion (digit 9) and Auditory [digit 1}, you will perform a Hypothesis Testing on the mean between the data in the Extraversion column versus the Auditory column