Problem
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.**