There is a sample data collected for a survey and prepared for analysis. Read the following survey details, the questions and how they coded. You will find the data set as an attached file. Answer the following questions.

Function First Federal Credit Union $($FFFCU$)$ is a local financial institution with thirty branch offices. It has $137,000$ credit union members and nearly $$2$ billion in assets. Landry Parker, Vice$-$President for Marketing, has conducted a member satisfaction survey for the past four years. In the survey, members rated their satisfaction with various aspects of the credit union, indicated their use of the internet and the FFFCU Web site and indicated various personal characteristics. Over $1000$ members were surveyed each year.

The database results are from a sub$-$sample $406$ respondents from the Downtown, Riverdale, The Heights, Palm City and South Town branch offices over the past four years.

The database is organized as follows:

ID Respondent identification number

Year Year of survey from $1$ to $4$

Q$1$ Branch used most often $($Downtown $=1,$ Riverdale$=2,$ The Heights $=3,$ Palm City $=4,$ South Town $=5,$ don$$t use a branch office $=6)$

Q$2$ Satisfaction with FFFCU staff on product knowledge $(1=$ very dissatisfied, $6=$ very satisfied$)$

Q$3$ Satisfaction with FFFCU on products and services offered

Q$4$ Satisfaction with FFFCU on accuracy of transactions

Q$5$ Satisfaction with FFFCU on information provided on products and services

Q$6$ Satisfaction with FFFCU on information provided on special promotions

Q$7$ Satisfaction with FFFCU on availability of methods used to access accounts

Q$8$ Overall satisfaction with FFFCU

Q$9$ Has Internet access at home or work $(1=$ yes, $2=$ no$)$

Q$10$ Has visited FFFCU Web site in past year $(1=$ yes, $2=$ no$)$

Q$11$ Satisfaction with FFFCU Web site as source of information

Q$12$ How joined FFFCU $(1=$ through employment, $2=$ Function County resident, $3=$ relative of FFFCU member$)$

Q$13$ How long a member of FFFCU $(1=$ under one year, $2=1-3$ years, $3=$ over three years$)$

Q$14$ Age category $(1=$ under $25,2=25-34,3=35-54,4=55-64,5=65+)$

Q$15$ Annual household income $(1=$ $$20,000$ and below, $2=$ $$20,001$ $$25,000,3=$ $$25,001-$ $ $50,000,4=$ $$50,001-$ $$75,000,5=$ $$75,001-$ $$100,000,6=$ over $$100,000)$

Q$16$ Education level $(1=$ high school graduate or below, $2=$ some college to college graduate, $3=$ some graduate education to graduate degree$)$

QUESTIONS

Chapter $10$

$1.$ Can you create a total satisfaction index score by adding these six variables? These variables are; satisfaction with FFFCU staff on product knowledge, satisfaction on products and services offered, satisfaction on accuracy of transactions, satisfaction on information provided on products and services, satisfaction on information provided on special promotions, satisfaction on availability of methods used to access accounts.

Chapter $11$

$2.$ What is the frequency distribution of Q$8$Rating of Satisfaction of FFFCU Overall$?$

$3.$ What are the mean, mode, median, standard deviation and variance for that question?

Chapter $12$

$4.$ When comparing those who have internet access to those who do not, is there a significant difference in overall satisfaction?

$5.$ Is satisfaction with accuracy of transactions significantly correlated with overall satisfaction?

$6.$ Build a bivariate regression with overall satisfaction as the dependent variable and satisfaction with accuracy of transactions as the independent variable.

$7.$ Build a multiple regression model with overall satisfaction as the dependent variable and product knowledge, satisfaction on products and services offered, satisfaction on accuracy of transactions, satisfaction on information provided on products and services, satisfaction on information provided on special promotions, satisfaction on availability of methods used to access accounts and satisfaction with the Web site as source of information as the independent variables.