Question

11- What is the test statistic for testing the overall linear (the test outlined in question 10)?

Select one:

a. 1.86×10−11

b. 22

c. 0.35

d. 7.64

e. -0.21

Create a pivot table to display how does the type of hitter and years of experience influence the number of major home runs. What is the average number of major home runs for power hitters that have 2 or less years of experience (0, 1 or 2 years of experience)? (hint: “grouping” would be helpful)

Select one:

a. 10

b. 17.78

c. 13.89

d. 15.6

e. 13.15

17- Including the new variable for type of the hitter inside the regression model, which of the following is true when comparing power hitters with contact hitters,when other predictor variables are held constant?

Select one:

a. The difference in major home run hits between the two types of hitters is not significant

b. Power hitters have 3.58 MORE major home run hits than contact hitters on average

c. Power hitters have 3.58 LESS major home run hits than contact hitters on average

d. Power hitters have 4.5 MORE major home run hits than contact hitters on average

e. Power hitters have 4.5 LESS major home run hits than contact hitters on average

Major HR	Minor HR	Age	Years Pro	Type of hitter
19	13	19	3	power hitter
23	15	21	3	contact hitter
6	4	22	5	contact hitter
6	12	21	3	contact hitter
7	21	19	2	contact hitter
18	19	21	3	contact hitter
3	0	19	2	contact hitter
7	8	20	1	contact hitter
20	20	21	3	power hitter
9	12	22	4	contact hitter
11	16	23	6	power hitter
7	10	21	5	power hitter
25	19	22	3	power hitter
4	11	19	3	contact hitter
35	19	20	3	power hitter
13	12	18	1	power hitter
18	11	21	3	power hitter
6	14	21	2	contact hitter
8	10	19	2	power hitter
12	1	19	2	power hitter
20	18	24	5	power hitter
4	22	18	1	contact hitter
11	13	18	2	power hitter
32	20	23	5	power hitter
2	4	19	2	contact hitter
22	16	20	4	power hitter
2	2	19	2	contact hitter
2	2	21	2	contact hitter
9	9	20	2	power hitter
32	19	19	2	power hitter
3	6	19	1	contact hitter
10	9	23	6	contact hitter
5	6	21	4	contact hitter
24	18	20	2	power hitter
10	12	21	3	contact hitter
10	11	22	3	contact hitter
19	12	21	3	contact hitter
2	1	23	4	contact hitter
16	10	21	3	contact hitter
11	26	19	4	contact hitter
28	15	23	3	power hitter
20	13	24	7	contact hitter
18	12	24	4	power hitter
9	14	21	3	contact hitter
0	5	18	0	contact hitter
10	12	22	2	contact hitter
20	29	19	2	contact hitter
11	10	20	2	power hitter
12	10	22	3	contact hitter
8	19	20	4	power hitter
12	9	23	5	contact hitter
21	13	21	4	power hitter
11	11	21	2	power hitter
28	24	21	3	power hitter
4	7	20	2	power hitter
38	22	19	2	power hitter
8	7	23	5	power hitter
7	8	21	4	contact hitter
4	6	18	1	power hitter
15	11	23	6	contact hitter
12	12	18	1	power hitter
3	3	19	3	contact hitter
8	12	18	1	contact hitter
3	0	21	2	contact hitter
24	22	22	4	power hitter
23	14	23	5	power hitter
17	12	18	1	power hitter
22	17	23	4	power hitter
23	12	24	6	contact hitter
12	11	23	5	contact hitter
6	8	19	2	contact hitter
34	23	20	2	power hitter
5	15	20	4	power hitter
21	13	22	3	power hitter
13	24	21	2	power hitter
4	5	24	3	power hitter
8	17	23	4	contact hitter
20	11	21	4	contact hitter
17	10	20	4	contact hitter
11	19	23	4	contact hitter
23	25	23	3	power hitter
7	28	23	3	power hitter
5	2	23	3	contact hitter
25	12	24	4	contact hitter
12	25	20	2	contact hitter
6	7	20	1	power hitter
21	17	22	5	contact hitter
28	26	23	2	power hitter
7	5	23	5	contact hitter
21	11	19	3	contact hitter
5	13	20	3	power hitter
22	21	20	2	contact hitter
7	6	21	3	contact hitter
3	6	21	3	contact hitter
7	8	22	4	contact hitter
13	14	18	2	power hitter
15	12	24	7	contact hitter
26	20	20	2	power hitter
18	10	24	4	contact hitter
4	7	19	1	contact hitter
19	14	22	4	power hitter
16	33	22	3	power hitter
12	21	21	2	contact hitter
10	14	18	1	power hitter
23	12	20	4	power hitter
6	9	23	3	contact hitter
16	15	19	2	contact hitter
10	24	22	3	contact hitter
3	0	22	4	power hitter
2	7	19	2	contact hitter
17	12	24	6	power hitter
6	11	19	2	power hitter
19	12	19	3	power hitter
6	5	24	4	contact hitter
10	9	20	2	contact hitter
6	18	21	3	power hitter
3	2	20	2	contact hitter
11	11	20	2	power hitter
18	10	19	1	contact hitter
4	6	21	2	contact hitter
6	12	21	3	contact hitter
29	31	21	2	power hitter
12	16	18	2	contact hitter
7	22	20	2	contact hitter
8	35	20	1	power hitter
30	23	23	3	power hitter

Answer 1

The first and third questions are related to some pervious question, hence need more information to solve it.

Second quesiton solved.

Create a pivot table to display how does the type of hitter and years of experience influence the number of major home runs. What is the average number of major home runs for power hitters that have 2 or less years of experience (0, 1 or 2 years of experience)? (hint: “grouping” would be helpful)

e. 13.15

How to get the answer.

Step 1 : Put the data in excel and highlight as shown.
Go to insert -> Pivot table and you will the create Pivot table input window. Check that the entire data is selected.

Review View Developer Help Get Add-ins File Home Insert Draw Page Layout Formulas Data o Online Pictures 3D Models Shapes SmartArt Pivot Table Recommended Table Pictures Pivot Tables Icons Screenshot Tables Illustrations My Add-ins - Recommended Maps PivotChart Charts : 3D Map Tours Add-ins Charts 3 Major HR F G H I J K L M N 19 Create Pivot Table WN 15 o co E 1 Major HR Minor HR Age Years Pro Type of hitter: 3 power hitter 3 contact hitter : 5 contact hitter 6 12 21 3 contact hitter 7 21 19 2 contact hitter 1921 3 contact hitter 2 contact hitter 1 contact hitter 3 power hitter 4 contact hitter i 6 power hitter : 5 power hitter 3 power hitter 3 contact hitter 3 power hitter 1 power hitter 3 power hitter 14 21 2 contact hitter 8 1019 2 power hitter 1 19 2 power hitter 2018 24 5 power hitter 4 22 18 1 contact hitter 11 13 18 2 power hitter Choose the data that you want to analyze Select a table or range Table/Range: Sheet1!SAS1:SES127| O Use an external data source Choose Connection... Connection name: Use this workbook's Data Model Choose where you want the PivotTable report to be placed O New Worksheet O Existing Worksheet Location: Choose whether you want to analyze multiple tables Add this data to the Data Model Būūū OK | Cancel NNNN

Step 2 : You get a new sheet as shown below

lo B C 17 Insert Slicer 57 Insert Timeline Filter Connections Pivot Table Group Actions Calculations Active Field Show Refresh Change Data Source PivotChart Recommended Pivot Tables Tools Filter Data A3 * for A B C D E F G H I PivotTable Fields - Choose fields to add to report: 4 Pivottablei Search 10 To build a report, choose fields from the Pivot Table Field List Major HR Minor HR Age Years Pro Type of hitter More Tables... TIITTO ILITI IIIIIIII OHIT OKO Drag fields between areas below: W 600 VOU AWNO Ill Columns Filters Rows Σ Values

Step 3 : We need to filter type of hitter and select the number of years of experience. Hence drag and put both these field in the filter box. As shown

Next we need the average number of major home runs the values box

C D E F G H - B (All) (All) 1 Years Pro 2 Type of hitter Pivot Table Fields Choose fields to add to report: 3 4 Sum of Major HR 1657 Search in mo nmin Major HR Minor HR Age Years Pro Type of hitter More Tables... Drag fields between areas below: III Columns Y Filters Years Pro Type of hitter 00 00 Rows Σ Values Sum of Major HR

Step 4 : We get the sum of the all the Home runs , we need the average, there we do the following get the needed result

Right click on Sum of Major HR and select Value Field settings.

Minor HR Age Years Pro Type of hitter More Tables... Drag fields between areas * Y Y Filters Years Pro Type of hitter Σ X Move Up Move Down Move to Beginning Move to End Move to Report Filter Move to Row Labels Move to Column Labels Move to Values Remove Field Value Field Settings... Sum of Major HR Rows Defer Layout Update Update

In the window that come select Average and we get the needed value.

Value Field Settings ? X Source Name: Major HR Custom Name: Average of Major HR Summarize Values By Show Values As Summarize value field by Choose the type of calculation that you want to use to summarize data from the selected field Sum Count Average Max Min Product Number Format OK | Cancel et hittar

final answer

C D E F PivotTable Fields x JB (All) (All) 1 Years Pro 2 Type of hitter Choose fields to add to report: Average of Major HR 13.15079365 Search ON Major HR Minor HR Age ✓ Years Pro Type of hitter More Tables... O Drag fields between areas below: III Columns 7 Filters Years Pro Type of hitter Rows Σ Values Average of Major HR NS