This is for Microsoft VBA The user (me) will enter as many numbers as he wishes

Question

This is for Microsoft VBA
The user (me) will enter as many numbers as he wishes in column A starting in cell A1 on Sheet1. Create a run button in Sheet1 that executes a macro named problem1. This macro solves the following problem:
Determine the number of values input by the user and store this value in a variable named N.
Create an array named X that has N elements.
Obtain the values from the worksheet and store them in X.
Using the values in the array, calculate the mean value, minimum value, maximum value, and standard deviation of these numbers. Hint: You need to calculate the mean first before calculating the standard deviation.
Output these four values to the user in cells D2-D5.
**Do not use the built-in functions AVERAGE, SUM, MIN, MAX, or STDEV to complete this problem.**

Explanation / Answer

First we tend to kind the primary column ( sixteen nine and nineteen ) to allow nine sixteen nineteen

Next the second column ( four ten seven|and seven} ) to allow four 7 ten

Column 3 ( three eleven and one ) to allow one three eleven

Column four ( thirteen twelve two|and a couple of|and a pair of} ) to allow 2 twelve thirteen

Column 5 ( five seventeen and fourteen ) to allow five fourteen seventeen

Column six ( half dozen fifteen and twenty ) to allow half dozen fifteen twenty

and column seven ( eight and eighteen ) to allow eight eighteen

Reassembling the array we tend to currently have:

9 four one a pair of five half dozen eight sixteen seven three twelve fourteen fifteen eighteen nineteen ten eleven thirteen seventeen twenty
1, 2, 5, 3, 7, 4, 8, 6, 9, 10, 11, 13, 12, 14, 15, 16, 17, 18, 19, 20

Most of the weather area unit within the right place, and also the last run of the algorithmic program may be a standard insertion kind (this is far shell kind is taken into account a generalization of the insertion sort).

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.