SYM 506 Week 2 Assignment Help

SYM 506 Week 2 Assignment Help | Grand canyon University 

Complete the problems below from the textbook. You will need to use the "Lincolnville School District Bus Data" and the "Century National Bank Data" files for this assignment.

1.      Chapter 3 – Problem 88

2.      Chapter 4 – Problem 25

           The Director of Planning for Devine Dining Inc. wishes to study the relationship be-tween the gender of a guest and whether the guest orders dessert. To investigate the relationship, the manager collected the following information on 200 recent customers.

Gender

Dessert Ordered Male Female Total

Yes                         32     15           47

No                          68     85           153

Total                     100   100          200

a. What is the level of measurement of the two variables? 

 b. What is the above table called? 

c. Does the evidence in the table suggest men are more likely to order dessert than women? Explain why. 

3.      Chapter 4 – Problem 46

      Refer to the Lincolnville School District bus data.

       a. Referring to the maintenance cost variable, develop a box plot. What are the mini-mum, first quartile, median,            third quartile, and maximum values? Are there any outliers?

       b. Using the median maintenance cost, develop a contingency table with bus manufac-turer as one variable and                 whether the maintenance cost was above or below the median as the other variable. What are your                                    conclusions?

4.      Chapter 5 – Problem 94

          Refer to the Lincolnville school bus data. Set up a variable that divides the age of the buses into three groups: new (less than 5 years old), medium (5 but less than 10 years), and old (10 or more years). The median maintenance cost is $4,179. Based on this value, create a variable for those less than or equal to the median (low maintenance) and those more than the median (high maintenance cost). Finally, develop a table to show the relationship between maintenance cost and age of the bus.

 a. What percentage of the buses are less than five years old?

b. What percentage of the buses less than five years old have low maintenance costs?

c. What percentage of the buses ten or more years old have high maintenance costs?

 d. Does maintenance cost seem to be related to the age of the bus? Hint: Compare the maintenance cost of the old buses with the cost of the new buses? Would you con-clude maintenance cost is independent of the age?

5.    Chapter 4 Case A – Century National Bank

1- Develop a graph or table that portrays the checking balances. What is the balance of a typical customer? Do many customers have more than $2,000 in their accounts? Does it appear that there is a difference in the distribution of the accounts among the four branches? Around what value do the account balances tend to cluster?

The most appropriate graphs are being provided below and these graphs shall help in doing the activities in a proper manner. 

For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.

Submit output in one Excel file.