Data Analysis Requirements

$1.$ Upload the MS Excel CSV Data Analysis Assignment file to SPSS$/$PSPP$.$ The file is located on Moodle in the Data Analysis Workshop files. You are required to paste the SPSS$/$PSPP Output file report for this requirement. $(10$ Marks$)$

Use the following Data Description to complete the uploaded file.

Data Description

Var$1$Respondent's identification number $($ID$)$

Var$2$Location of residence $($LOCATION$)$

$1$ Urban

$2$ Rural

Var$3$Respondent's gender $($GENDER$)$

$1$ Male

$2$ Female

$9$Prefer not to state.

Var$4$How Happy do you feel today $($FEELINGS$)$

$1$ Very Unhappy

$2$ Unhappy

$3$OK

$4$Happy

$5$Very Happy

$6$Prefer not to state.

Var$5$Respondent's age $($AGE$)$

Var$6$Respondent's religious affiliation $($RELIGION$)$

$1$Seventh Day Adventist

$2$Catholic

$3$Baptist

$4$Methodist

$5$ Other

Var$7$ Respondents mothers education $-$ years of schooling $($MAEDUC$)$

Var$8$Respondent's highest level of education completed $($EDUC$)$

$1$Grade school

$2$Some high school

$3$High school graduate

$4$Some College, but no degree

$5$Trade or technical school

$6$Associate degree

$7$Bachelors degree

$8$Post Graduate Degree

$9$None

Var$9$Income of respondents $($INCOME$)$

$1$Less than $$10,000$

$2$$$10,000$ to less than $$20,000$

$3$$$20,000$ to less than $$30,000$

$4$$$30,000$ to less than $$40,000$

$5$$$40,000$ to less than $$50,000$

$6$$$50,000$ to less than $$60,000$

$7$$$60,000$ to less than $$70,000$

$8$$$70,000$ to less than $$80,000$

$9$$$80,000$ to less than $$100,000$

$10$$$100,000$ or more

$99$Prefer not to state

Var$10$ Respondent's ethnicity $($ETHNIC$)$

$1$White

$2$Black $/$African$-$American

$3$Hispanic $/$ Latino

$4$American Indian or Alaska Native

$5$Pacific Islander

$6$Asian

$9$Other

Var$11$How knowledgeable are you about health issues $($GenHealth$)$

$1$ Little or no knowledge

$2$ Knowledgeable

$3$ Very knowledgeable

$9$DK

Var$12$How knowledgeable are you about smartphones $($GenSmartPhone$)$

$1$ Little or no knowledge

$2$ Knowledgeable

$3$ Very knowledgeable

$9$DK

Var$13$How knowledgeable are you about technology $($GenTechnology$)$

$1$ Little or no knowledge

$2$ Knowledgeable

$3$ Very knowledgeable

$9$DK

Var$14$How knowledgeable are you about the environment $($GenEnvironment$)$

$1$ Little or no knowledge

$2$ Knowledgeable

$3$ Very knowledgeable

$9$DK

Var$15$How knowledgeable are you about social media $($GenSocialMedia$)$

$1$ Little or no knowledge

$2$ Knowledgeable

$3$ Very knowledgeable

$9$DK

Var$16$How knowledgeable are you about Internet Banking $($GenInternetBanking$)$

$1$ Little or no knowledge

$2$ Knowledgeable

$3$ Very knowledgeable

$9$DK

$2.$ Data cleaning all variables with the following values must be declared as missing:

Other

None

DK

Prefer not to state.

After completing the data cleaning exercise, you are required to paste the SPSS$/$PSPP Variable View screenshot for this requirement. $(12$ Marks$)$

$3.$ What are the religions with the highest and lowest frequencies? What per cent of the respondents are affiliated with these religious groups? What is the total percentage of respondents in both groups? Report and interpret your answer.$(6$ Marks$)$

$4.$ What are the total and individual frequencies and percentages of respondents education attained with the highest and lowest frequency? What is the total percentage of both categories? $(6$ Marks$)$

$5.$ What is the mode, mean, minimum and maximum for the AGE variable? What percentage of the respondents are associated with the mode? $(6$ Marks$)$

$6.$ If you ordered the ethnicities from highest to lowest frequencies. What are the two ethnicities with the middle frequencies? In responding to this question, provide the frequency and percentage for each group. $(6$ Marks$)$

$7.$ What are the highest and lowest frequencies for the feelings variable? In responding to this question, you are required to provide the frequencies and percentages and the total for the two groups. $(5$ Marks$)$

$8.$ Recode MAEDUC into a new variable MAEDUC$\_$Levels using the ranges below. You are required to add the label and value labels for the new variable. Report the typical values for the variables MAEDUC and MAEDUC$\_$Levels. What are the percentages for each value? For the recode process copy and paste the Output file information displayed. $(8$ Marks$)$

Value

MAEDUC$\_$Level

Value Label

$1-6$

$1$

Primary

$7-12$

$2$

Secondary

$13-19$

$3$

Tertiary

$9.$ Compute and report the Pearson correlation between the variables GenSmartPhone and GenSocialMedia. In reporting your findings include the significance and the strength of the relationship as well as the output table.$(8$ Marks$)$

$10.$ Is there a significant difference between income based on location? In responding to this question justify your answer and paste the T$-$test table as part of the report.$(7$ Marks$)$

$11.$ Consider the following variables as items for a proposed Gen$\_$Knowledge$\_$Index :

GenHealth

GenSmartPhone

GenTechnology

GenEnvironment

GenSocialMedia

GeninternetBanking

a$)$ Compute the Cronbachs Alpha for the proposed Gen$\_$Knowledge$\_$Index index. In answering this question, you must provide the tables associated with Cronbach Alpha. $(3$ Marks$)$

b$)$ Can the reliability of this index be improved? Justify your answer.$(3$ Marks$)$

c$)$ Using the results of questions $11$a$-$b$,$ create a Gen$\_$Knowledge$\_$Index index using the most appropriate variables. As verification paste the output report from this process.$(3$ Marks$)$

Tip: Unless you had decided to remove $1$ or more items to improve the Croncbachs Alpha, the index should be created with all $6$ variables. The name of the newly created index is Gen$\_$Knowledge$\_$Index.

$12.$ Test the following hypotheses:

a$)$ H$1$: There is a significant difference in Gen$\_$Knowledge$\_$Index based on gender.

$($Hint: Independent Samples T$-$test, Gen$\_$Knowledge$\_$Index by Gender$)(8$ Marks$)$

b$)$ H$2$: There is a significant difference in Gen$\_$Knowledge$\_$Index based on MAEDUC$\_$Level $($created at question $8$ above$)?$

$($Hint: One way ANOVA, IGen$\_$Knowledge$\_$Index by MAEDUC$\_$Level$)(9$ Marks$)$

You are required to provide the relevant tables and analyse your results for both $($a$)$ and $($b$)$ above.