Calculate the average over the three test grades

Assignment Help Computer Engineering

Reference no: EM132075861

Need Help Figuring Out Practice Code In Language VBA (Visual Basics For Applications in Excel)

The data is included in this table:

YOU SHOULD PASTE THE TABLE IN EXCEL FROM ROWS C5 TO F5 AND COLUMNS FROM C5 TO C55

Test 1

Test 2

Test 3

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

100
84
80
78
71
85
66
91
81
84
95
62
51
74
62
55
69
88
61
59
52
79
89
66
62
88
62
94
55
94
80
52
54
87
65
51
97
65
100
63
93
78
58
54
73
96
50
71
59
55

72
77
95
58
65
62
81
98
74
62
72
75
64
59
50
62
90
77
95
92
87
78
54
60
84
87
94
96
78
72
83
64
85
96
52
73
67
77
74
58
92
59
81
62
56
99
90
75
67
81

68
88
93
83
88
56
83
63
83
100
91
55
70
83
62
85
52
50
75
61
74
68
96
64
52
94
65
74
99
84
87
65
61
65
71
91
80
89
70
88
94
86
65
96
86
91
61
68
67
84

The table includes 3 tests for students.

a) Use code name wsEx assign cell C5 to the variable rngA Use cell C5 as a reference cell to do the following and use With construction:

b) Format headers with red font, horizontal center, italics (start from C5 and use offset and end method to find the range for headers. Don't just use A1 address such as Range("C5:F5"))

c) Calculate the average for each Test grade and put them on the second empty row below the grades(start from C5 and use offset to specify the range for saving average and use R1C1 reference style for formula. FormulaR1C1 will be "=Average(R[#]C:R[#]C)")

d) The standard deviation for each Test grade and put them on the next row

e) The minimum grades and put them below the standard deviation

f) The maximum grades and put them below the minimum

g) On the first column with data, label each of the four rows added appropriately (e.g., Average, StdDev, Min, Max)

h) Calculate the average over the 3 Test grades and put them on the second empty column to the right of the last column with Grades, Label the column "Average" (average over 3 test: FormulaR1C1 will be "=Average(RC[#]:RC[#])")

i) Sort the data from largest to smallest based on grade in Test 1

Reference no: EM132075861

Questions Cloud

Determine the equivalent units for june for the first proces : a) Determine the equivalent units for June for the first process. b) Compute the costs per equivalent unit for June for the first process.

Record the entries to assign service salaries : Ruiz Engineering Contractors incurred service salaries and wages of $44,000, Record the entries to assign service salaries and wages and to apply overhead

Journalize the entries for the completion of the two jobs : In March, Stinson Company completes Jobs 10 and 11. Journalize the entries for the completion of the two jobs and the sale of Job 10

What is the business risk and financial risk : What's the purpose for finding the optimal capital structure in a firm? What is the business risk and financial risk and their relations?

Calculate the average over the three test grades : Calculate the average over the 3 Test grades and put them on the second empty column to the right of the last column with Grades.

Company to outsource manufacturing operations : From a system viewpoint, what are some of the environmental issues involved in a decision by the company to outsource manufacturing operations

Newco is a young company that has yet to make a profit : Newco is a young company that has yet to make a profit. You are trying to place a value on the stock, but it pays no dividends and you obviously

Compute predetermined overhead rate for each activity base : Marquis Company estimates that annual manufacturing overhead costs will be $874,000. Compute the predetermined overhead rate for each activity base

Develop a corporate ife matrix for volkswagen group : Develop a Corporate IFE Matrix for Volkswagen Group.

User Account

All Pages