Data shows graduate program admission decisions (Yes: 1 and No: 2), GRE score and undergraduate GPA for twenty-five students.

Tasks:

Examine if the given data is suitable for the application of linear discriminant analysis.

Create a linear discriminant function predicting admission decisions.

Comment on the classification accuracy.

Predict the admission decision given GRE score = 690 and GPA = 3.2.

Perform logistic regression analysis for the data.

Compare the classification accuracies of both methods.

Use Minitab

Data shows graduate program admission decisions (Yes: 1 and No: 2), GRE score and undergraduate GPA for twenty-five students.

Tasks:

Examine if the given data is suitable for the application of linear discriminant analysis.

Create a linear discriminant function predicting admission decisions.

Comment on the classification accuracy.

Predict the admission decision given GRE score = 690 and GPA = 3.2.

Perform logistic regression analysis for the data.

Compare the classification accuracies of both methods.

question13: TABLE 14-1

A manager of a product sales group believes the number of sales made by an employee ( Y) depends on how many years that employee has been with the company ( X ₁) and how he/she scored on a business aptitude test ( X ₂). A random sample of 8 employees provides the following:

Referring to Table 14-1, for these data, what is the estimated coefficient for the variable representing scores on the aptitude test?

question 14:

TABLE 14-1

A manager of a product sales group believes the number of sales made by an employee ( Y) depends on how many years that employee has been with the company ( X ₁) and how he/she scored on a business aptitude test ( X ₂). A random sample of 8 employees provides the following:

Referring to Table 14-1, if an employee who had been with the company 5 years scored a 9 on the aptitude test, what would his estimated expected sales be?

Java

Starter Code:

Reading journal articles can be challenging for students, as they are often technical in nature. A high school that prides itself on preparing students for college wants to purchase journals that are written at a level accessible to students. The school librarian recruits four students with varying academic ability to read articles from four different journals and rate their readability from 1 (very difficult to read and understand) to 7 (very easy to read and understand). Some hypothetical data are shown in the table.

Table: Journal and Readability

a) Perform an F test at alpha level .05, using excel. Submit your workbook showing the results.

b) What is the conclusion in terms of the null hypothesis, reject or fail to reject? Explain why.

Use this constant dictionary as a global variable:

tile_dict = { 'A': 1, 'B': 3, 'C': 3, 'D': 2, 'E': 1, 'F': 4, 'G': 2, 'H': 4, 'I': 1, 'J': 8, 'K': 5, 'L': 1, 'M': 3, 'N': 1, 'O': 1, 'P': 3, 'Q': 10, 'R': 1, 'S': 1, 'T': 1, 'U': 1, 'V': 4, 'W': 4, 'X': 8, 'Y': 4, 'Z': 10 }

Implement function scrabblePoints(word) that returns the calculated points for the word based on the tile_dict above. The word parameter is a string. This function takes the string and evaluates the points based on each letter in the word (points per letter is set by the global dictionary). P or p is worth the same points. No points calculated for anything that is not A-Z or a-z.

[You may use upper() and isalpha() ONLY and no other method or built-in function]

Examples:

word = “PYTHON”

print(scrabblePoints(word))

returns:

14

word = “hello!!”

print(scrabblePoints(word))

returns:

8

word = “@#$=!!”

print(scrabblePoints(word))

returns:

0

Note: This function relies on scrabblePoints. Function you solved in Question 2.

Implement function declareWinner(player1Word = “skip”, player2Word = “skip”) that returns either “Player 1 Wins!”, “Player 2 Wins!”, “It’s a Tie”, “Player 1 Skipped Round”, “Player 2 Skipped Round”, “Both Players Skipped Round”. The player1Word and player2Word parameters are both type string. Assume input is always valid. This function should call on the function scrabblePoints to earn credit.

[No built-in function or method needed]

Examples:

player1Word = “PYTHON”

player2Word = “Pizza”

     print(declareWinner(player1Word, player2Word))

     returns:           

     Player 2 Wins!

              print(declareWinner(player1Word))

              returns:           

              Player 2 Skipped Round

A chain of four matrices A₁, A₂, A₃ and A₄, with order 3 X 4, 4 X 2, 2 X 8 and 8 X 7 respectively. Deduce m[1, 4] to find best possible minimum number of multiplication

An article in the journal PLOS ONE describes a study in which the oviposition preferences of Tecia solanivora, the Central American potato tuberworm or Guatemalan potato moth, are compared across different varieties of Solanum tuberosum (potato).

Suppose that Paul, a plant pathologist, collects a sample of 194 potato plants. Paul records the total number of T. solanivora eggs laid on and around each plant. The egg counts are provided in the data file.

CrunchIt!    CSV   Excel   JMP   Mac Text    Minitab   PC Text   R   SPSS   TI Calc  

Let ? be a random variable taking on values equal to the number of eggs laid on or around each plant.

Compute   x¯ , the mean number of eggs laid on or around each plant. Report your answer to at least two decimal places of precision.

x¯=

eggs

Compute  s , the sample standard deviation of the number of eggs laid on or around each plant. Report your answer to at least three decimal places of precision.

s=

eggs

"EGGCNT"
6
3
3
10
1
80
9
5
5
39
2
0
64
31
21
23
9
17
6
20
2
7
5
30
29
6
52
5
4
1
47
8
15
43
3
23
2
5
54
22
13
12
20
4
2
4
13
75
28
13
72
78
5
78
58
63
60
22
16
48
3
2
81
6
18
1
60
40
15
9
11
39
0
14
2
49
4
52
1
4
0
45
10
0
3
7
3
53
4
0
5
16
20
2
0
0
0
27
1
0
28
1
9
0
0
0
10
0
2
0
31
1
0
10
8
2
10
0
39
42
33
3
2
0
0
0
0
0
7
6
0
2
26
7
32
8
32
1
11
2
1
3
1
0
26
8
0
7
2
1
0
23
0
3
98
3
3
3
0
13
0
2
12
0
10
18
24
115
10
10
0
0
0
2
28
2
0
27
0
3
0
8
0
7
27
29
3
0
70
9
7
17
15
2

Question 1

Office Support, Inc. provides on-site repair for most large photocopy machines. It currently has five trained repair teams that it sends out on an on-call basis. Since the company advertises one-day service, it will not accept more than five requests for service per day. Two months ago, the vice president started considering expanding the workforce. At that time he asked the call desk to record the actual calls for each of the next 40 days. The data to respond to the questions below are provided in the Office worksheet. Define the random variable x as the number of service calls per day.   Clearly x is a discrete random variable.

4 points: Use built-in Excel functions to find the minimum and maximum values of x. That is, find the minimum number and maximum number of service calls per day over the 40 day period.   

Place the minimum in cell E2.

Place the maximum in cell E3.

4 points: Based on the minimum and maximum number of service calls per day in the sample of 40 days, specify the complete range of x. That is, make a list of all possible outcomes of x under the column labeled x starting in cell G2.

9 points: Using the built-in Excel function named COUNTIF, calculate the count (frequency) of each outcome (x) in the sample. In general, your function with its arguments will appear as
“=COUNTIF(argument 1, argument 2),” where argument 1 is the data range and argument 2 is a cell reference containing a specific outcome value. Start by finding the count for x = 0, then finding the count for all other outcomes. The values will be under the column labeled “Count.”

In the first unused cell following the last count value (from above), use Excel’s built-in SUM function to calculate the total count (frequency). For example, if the count cells went from H2:H7, enter the sum in cell H8. Format the sum cell (box, color, etc.) to highlight that it contains the sum of the values above it.