+1(978)310-4246 credencewriters@gmail.com
  

Complete the problems below from the textbook. You will need to use the “Baseball 2016 Data,” “Lincolnville School District Bus Data,” and the “Century National Bank Data” files for this assignment.  The files are located in the topic materials.

Chapter 13 – Problem 63
Chapter 13 – Problem 64
Chapter 14 – Problem 35
Chapter 14 Case A – Century National Bank

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.ChartDataSheet_

This worksheet contains values required for MegaStat charts.

Boxplot 1/28/2010 16:03.39

2 741

2 806

3 806

3 827

1 827

3 827

3 851.5

2 851.5

2 908

2 851.5

1 851.5

1 806

2 806

1 669.5

3 669.5

1 737.75

3 737.75

1 919.75

3 919.75

1 988

3 988

Boxplot 1/28/2010 16:06.08

2 741

2 806

3 806

3 827

1 827

3 827

3 851.5

2 851.5

2 908

2 851.5

1 851.5

1 806

2 806

1 669.5

3 669.5

1 737.75

3 737.75

1 919.75

3 919.75

1 988

3 988

Dotplot 1/28/2010 16:06.08

741 1

751 1

757 1

757 2

760 1

774 1

775 1

780 1

784 1

785 1

790 1

792 1

798 1

799 1

799 2

800 1

802 1

803 1

804 1

806 1

806 2

809 1

812 1

815 1

815 2

815 3

816 1

816 2

817 1

817 2

817 3

818 1

819 1

819 2

821 1

822 1

823 1

826 1

827 1

827 2

827 3

828 1

830 1

831 1

832 1

835 1

836 1

837 1

838 1

839 1

842 1

842 2

842 3

844 1

845 1

846 1

847 1

848 1

849 1

851 1

853 1

856 1

857 1

857 2

858 1

859 1

859 2

864 1

865 1

866 1

866 2

869 1

870 1

873 1

874 1

882 1

883 1

885 1

895 1

908 1

Boxplot 1/28/2010 16:08.20

2 741

2 806

3 806

3 827

1 827

3 827

3 851.5

2 851.5

2 895

2 851.5

1 851.5

1 806

2 806

1 669.5

3 669.5

1 737.75

3 737.75

1 919.75

3 919.75

1 988

3 988

1.8 980

1.8 1008

Dotplot 1/28/2010 16:08.20

741 1

751 1

757 1

757 2

760 1

774 1

775 1

780 1

784 1

785 1

790 1

792 1

798 1

799 1

799 2

800 1

802 1

803 1

804 1

806 1

806 2

809 1

812 1

815 1

815 2

815 3

816 1

816 2

817 1

817 2

817 3

818 1

819 1

819 2

821 1

822 1

823 1

826 1

827 1

827 2

827 3

828 1

830 1

831 1

832 1

835 1

836 1

837 1

838 1

839 1

842 1

842 2

842 3

844 1

845 1

846 1

847 1

848 1

849 1

851 1

853 1

856 1

857 1

857 2

858 1

859 1

859 2

864 1

865 1

866 1

866 2

869 1

870 1

874 1

882 1

883 1

885 1

895 1

980 1

1008 1

Bus

Data Set 3 –Lincolnville School District Bus Data

ID Manufacturer Engine Type (0=diesel) Capacity Maintenance Cost Age Odometer Miles Miles

10 Keiser 1 14 4646 5 54375 11973

396 Thompson 0 14 1072 2 21858 11969

122 Bluebird 1 55 9394 10 116580 11967

751 Keiser 0 14 1078 2 22444 11948

279 Bluebird 0 55 1008 2 22672 11925

500 Bluebird 1 55 5329 5 50765 11922 Variables

520 Bluebird 0 55 4794 10 119130 11896

759 Keiser 0 55 3952 8 87872 11889 ID = Bus identification number

714 Bluebird 0 42 3742 7 73703 11837

875 Bluebird 0 55 4376 9 97947 11814 Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson)

600 Bluebird 0 55 4832 10 119860 11800

953 Bluebird 0 55 5160 10 117700 11798 Engine type = If the engine is diesel then engine type = 0; if the engine is gasoline, then engine type = 1)

101 Bluebird 0 55 195Sheet1

Balance ATM Services Debit Interest City

1756 13 4 0 1 2

748 9 2 1 0 1

1501 10 1 0 0 1

1831 10 4 0 1 3

1622 14 6 0 1 4

1886 17 3 0 1 1

740 6 3 0 0 3

1593 10 8 1 0 1

1169 6 4 0 0 4

2125 18 6 0 0 2

1554 12 6 1 0 3

1474 12 7 1 0 1

1913 6 5 0 0 1

1218 10 3 1 0 1

1006 12 4 0 0 1

2215 20 3 1 0 4

137 7 2 0 0 3

167 5 4 0 0 4

343 7 2 0 0 1

2557 20 7 1 0 4

2276 15 4 1 0 3

1494 11 2 0 1 1

2144 17 3 0 0 3

1995 10 7 0 0 2

1053 8 4 1 0 3

1526 8 4 0 1 2

1120 8 6 1 0 3

1838 7 5 1 1 3

1746 11 2 0 0 2

1616 10 4 1 1 2

1958 6 2 1 0 2

634 2 7 1 0 4

580 4 1 0 0 1

1320 4 5 1 0 1

1675 6 7 1 0 2

789 8 4 0 0 4

1735 12 7 0 1 3

1784 11 5 0 0 1

1326 16 8 0 0 3

2051 14 4 1 0 4

1044 7 5 1 0 1

1885 10 6 1 1 2

1790 11 4 0 1 3

765 4 3 0 0 4

1645 6 9 0 1 4

32 2 0 0 0 3

1266 11 7 0 0 4

890 7 1 0 1 1

2204 14 5 0 0 2

2409 16 8 0 0 2

1338 14 4 1 0 2

2076 12 5 1 0 2

1708 13 3 1 0 1

2138 18 5 0 1 4

2375 12 4 0 0 2

1455 9 5 1 1 3

1487 8 4 1 0 4

1125 6 4 1 0 2

1989 12 3 0 1 2

2156 14 5 1 0 2Sheet1

Balance ATM Services Debit Interest City

1756 13 4 0 1 2

748 9 2 1 0 1

1501 10 1 0 0 1

1831 10 4 0 1 3

1622 14 6 0 1 4

1886 17 3 0 1 1

740 6 3 0 0 3

1593 10 8 1 0 1

1169 6 4 0 0 4

2125 18 6 0 0 2

1554 12 6 1 0 3

1474 12 7 1 0 1

1913 6 5 0 0 1

1218 10 3 1 0 1

1006 12 4 0 0 1

2215 20 3 1 0 4

137 7 2 0 0 3

167 5 4 0 0 4

343 7 2 0 0 1

2557 20 7 1 0 4

2276 15 4 1 0 3

1494 11 2 0 1 1

2144 17 3 0 0 3

1995 10 7 0 0 2

1053 8 4 1 0 3

1526 8 4 0 1 2

1120 8 6 1 0 3

1838 7 5 1 1 3

1746 11 2 0 0 2

1616 10 4 1 1 2

1958 6 2 1 0 2

634 2 7 1 0 4

580 4 1 0 0 1

1320 4 5 1 0 1

1675 6 7 1 0 2

789 8 4 0 0 4

1735 12 7 0 1 3

1784 11 5 0 0 1

1326 16 8 0 0 3

2051 14 4 1 0 4

1044 7 5 1 0 1

1885 10 6 1 1 2

1790 11 4 0 1 3

765 4 3 0 0 4

1645 6 9 0 1 4

32 2 0 0 0 3

1266 11 7 0 0 4

890 7 1 0 1 1

2204 14 5 0 0 2

2409 16 8 0 0 2

1338 14 4 1 0 2

2076 12 5 1 0 2

1708 13 3 1 0 1

2138 18 5 0 1 4

2375 12 4 0 0 2

1455 9 5 1 1 3

1487 8 4 1 0 4

1125 6 4 1 0 2

1989 12 3 0 1 2

2156 14 5 1 0 2Problem 63

Problem 64

Problem 35

Case ACh 13 Problem 63

Refer to the Baseball 2016 data, which reports information on the 2016 Major League Baseball season. Let attendance be the dependent variable and total team salary, in millions of dollars, be the independent variable. Determine the regression equation and answer the following questions.
a. Draw a scatter diagram. From the diagram, does there seem to be a direct relationship between the two variables?
b. What is the expected attendance for a team with a salary of $80.0 million?
c. If the owners pay an additional $30 million, how many more people could they expect to attend?
d. At the .05 significance level, can we conclude that the slope of the regression line is positive? Conduct the appropriate test of hypothesis.
e. What percentage of the variation in attendance is accounted for by salary?
f. Determine the correlation between attendance and team batting average and between attendance and team ERA. Which is stronger? Conduct an appropriate test of hypothesis for each set of variables.

Problem 64
Refer to the Lincolnville School bus data. Develop a regression equation that expresses the relationship between age of the bus and maintenance cost. The age of the bus is the independent variable.
A. Draw a scatter diagram. What does this diagram suggest as to the relationship between the two variables? Is it direct or indirect? Does it appear to be strong or weak?
B. Develop a regression equation. How much does an additional year add to the maintenance cost? What is the estimated maintenance cost for a 10-year-old bus?
C. Conduct a test of hypothesis to determine whether the slope of the regression line is greater than zero. Use the .05 significance level. Interpret your finding from parts a,b, and c in a brief report.

Problem 35
Refer to the Lincolnville School district data. First, add a variable to change the type of engine (diesel or gas) to a qualitive variable. If the engine type is diesel, then set the qualitive variable to 0. If the engine type is gasoline, then set the qualitative variable to 1. Develop a regression equation using statistical software with maintenance cost as the dependent variable and age, odometer miles, miles since last maintenance, and engine type as the independent variables.

a. Develop a correlation matrix. Which independent variables have strong or weak correlations with the dependent variable? Do you see any problems with multicollinearity?
b. Use a statistical software package to determine the multiple regression equation. How did you select the variables to include in the equation? How did you use the information from the correlation analysis? Show that your regression equation shows a significant relationship. Write out the regression equation and interrupt its practical application. Report and interrupt R-square.
c. Develop a histogram or a stem-and-leaf display of the residuals from the final regression equation developed in part (a,b) for residuals analysis. Is it reasonable to conclude

error: Content is protected !!