Execute a macro that obtains data from the worksheet

Assignment Help Computer Engineering

Reference no: EM132177355

VBA Problem

Create a UserForm on Sheet1 that contains the following controls:

A Run button will be used to execute a macro that obtains data from the worksheet. The data will be used to calculate a0, a1, r, and the percentage probability. These four values will be output to four TextBoxes on the UserForm.

A fifth TextBox will tell the user if the relationship between the x and y data is "significant" or "not significant".

A Clear button will clear all five TextBoxes.

A Quit button will close the UserForm.

Also create a button on Sheet1 that will load the UserForm.

Executing the Program

When the user clicks the Run button on the UserForm, your program will perform the following tasks:

1) Call a Sub procedure named GetInput that obtains the x and y values from Sheet1 and stores the data in a 2D array named xyvalues.

2) Call a Sub procedure named CalcLine that calculates the coefficients for the best-fit line (a0 and a1) using the data in xyvalues.

3) Call a Function procedure named CalcR that calculates the correlation coefficient (r) using the data in xyvalues

4) Call a Function procedure named CalcPerProb that determines the percentage probability using the values of r and N, and the values of rO in Table C.

5) Call a Sub procedure named GiveOutput that outputs a0, a1, r, the percentage probability, and whether the correlation is significant to the five TextBoxes.

Reference no: EM132177355

Questions Cloud

When there is a permanent decrease in money supply growth : When there is a permanent decrease in money supply growth. Real interest rate and real output remain constant. What will happen to the price level?

What is the bandwidth-delay product for communication : As part of your new job, you've been asked to work on the link layer protocol for a wireless data connection with a bandwidth of 100 Mbps to the ISS.

Mediaville spend all of their income on books : Suppose the residents of Mediaville spend all of their income on books, CDs, and DVDs. In 2009, they buy 400 books for $3,200, 200 CDs for $1,400

What are some of brazil economic strengths : What are some of Brazil's economic strengths? And what are some significant differences between Brazil and the United States?

Execute a macro that obtains data from the worksheet : Call a Sub procedure named GetInput that obtains the x and y values from Sheet1 and stores the data in a 2D array named xyvalues.

What is the marginal cost of the thirteenth worker : A retailer has to pay $9 per hour to hire thirteen workers. If the retailer only needs to hire twelve workers, a wage rate of $7 per hour is sufficient.

What are the profitmaximizing output and advertising levels : What are the profitmaximizing output and advertising levels? What are the profits?

Write a program that prompts the user to input a number : Write a program that prompts the user to input a different number each time, repetitively (using either integer and/or float numbers).

Relevant demand function : You have 100 identical customers each with the relevant demand function Q=20-P (where Q is the hours per week and P is the per hour fee)

User Account

All Pages