A$.$ Section A$-$SPSS

Capture the data in SPSS

Use SPSS to get a table which gives the frequency distribution of the respondents according to gender. Comment on the frequency distribution.

Use SPSS to obtain the summary statistics $($Standard deviation, Variance, Minimum, Maximum, Kurtosis, Skewness$)$ for height. Comment on the skewness coefficient.

Use SPSS to draw a histogram for the heights of the respondents.

Use SPSS to draw a Box plot for the heights of the respondents. Comment on the distribution of the heights.

Using the Transform $$ Recodeintodif ferentvariables menu, create a new variable "Matdif" with label "Mathematics is a difficult subject" and three categories "Agree", "Neutral" and "Disagree". The "Agree" category should be a result of combining "Strongly agree" and "Agree" while "Disagree" will be a combination of "Strongly Disagree" and "Disagree". Do not forget to update the "Value" for the new variable in the variable view.

You are supposed to draw two histograms for comparing the heights of male and female respondents. Use Splitfile $$ Comparegroups to set your data so that you can compare males and females. Use the graph menu to draw the required histograms. Comment on how the two histograms compare.

Use the "Split File" menue to restore the settings to "Analyze all Cases".

You can use the "Select Cases" Menu to restrict your analysis to Males only i$.$e$.$ the results of any subsequent analysis will be for males only. Use this menu to find the distribution of car model preference among males.

B$.$ Section B$-$R

Write all your commands in one script file that you should save as "Script.R$"$

Capture the collected data in the form of a data frame with a name of your choice

For the data frame that you created above,

$($a$)$ Write an R command to extract the element in the $8^{th}$ row $4^{th}$ column.

$($b$)$ Write an R command to extract the ${15}^{th}$ row.

$($c$)$ Write an R command to extract the ${11}^{th}$ column.

$($d$)$ Write an R command to extract the elements in rows $2,1,19$ columns $2$ to $7$

$($e$)$ Write an R command to extract all people who like the BMW$.$

$($f$)$ Write an R command to extract data on all the female respondents who like the BMW$.$

$($g$)$ Write an R command to extract the data for all respondents who do not have Postgraduate degrees.

$($h$)$ Write an R command to extract the data for all respondents who BMW or Mercedes Benz..

$($i$)$ Add a new variable called heightcat and created by dividing the heights into $3$ equal categories named "short","Medium" and "tall".

$($j$)$ Write an R command to extract respondents whose height is below $130$ cm $.$

$($k$)$ Sort your data frame in descending order of height.

$($l$)$ Export your data frame to the file "final.csv$"$

$($m$)$ Create a histogram of the heights of these individuals. Comment on the histogram.

$($n$)$ Create a well labeled bar graph to depict the distribution of the car prefences of the respondents. Label the axis, and give a title to the bar graph. Comment on the bar graph.

$($o$)$ Perform a chi$-$squared test to determine if the heightcat is independent of gender? Comment on the results of the chi$-$square test