Create an array named x that has n elements

Assignment Help Computer Engineering

Reference no: EM131986610

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

Reference no: EM131986610

Questions Cloud

Meal based on a variety of factors : We make food choices at every meal based on a variety of factors. Describe at least five considerations that enter into food choice decisions.

How much interest and sinking fund payments were made : Interest-only payments are to be made quarterly commencing April 1, 2001 and the principal is to be repaid in full on January 1, 2009.

What happens to an hco or any organization : What happens to an HCO (or any organization) that fails in its strategic positioning (see Exhibit 1.14)?

What nominal annual interest rate is the company paying : The entire principle of $100,000 will be repaid in 2 years, but quarterly interest of $3300 must be paid every three months.

Create an array named x that has n elements : 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.

Impacts your employer practice : As a health care worker, why do you need a thorough understanding of the law as it impacts your employer's practice?

Find the pv of an ordinary annuity : Find the PV of an ordinary annuity that pays $1,000 each of the next 5 years if the interest rate is 15%. What is the annuity's FV?

Quality assurance to quality improvement : Discuss the history of CQI in public health in the US, including the change in emphasis from quality assurance to quality improvement.

What is meant by the scope and lifetime of a variable : What is meant by the scope and lifetime of a variable? If I declare a variable to be static, what changes, the scope or the lifetime? Why?

User Account

All Pages