Generate a scatter plot containg the information

Assignment Help Computer Engineering

Reference no: EM132177335

VBA coding:

The user will input between 3 and 20 data points for two variables on Sheet1 starting in cells A2 and B2 (the program should work if 3,4,5,...,20 data points are entered.)

Column A will contain the values for variable x and column B will contain the values for the variable y.

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.

Add code that will automatically generate a scatter plot containg the following information: -N data points -the best-fit line -labels for the x and y axis - chart title.

This code needs to be written in VBA, so the plot shows automatically after the macro is run, meaning there is no use of the Insert-Chart options in the Excel workbook.

Reference no: EM132177335

Questions Cloud

Design and implement an application reads in a set : Design and implement an application reads in a set of 200 grades into a two-dimensional array from a .txt file called studentanswers that represent.

Horizontal equity is achieved in taxation : If horizontal equity is achieved in taxation:

The augmenting path algorithm : What variation of the augmenting path algorithm (for network flow) was proposed to ensure that it ran in polynomial time?

How much is needed in the retirement account : At the end of January, How much is needed in the retirement account at the start of retirement for Tatenda to accomplish her goal

Generate a scatter plot containg the information : Add code that will automatically generate a scatter plot containg the following information: -N data points -the best-fit line -labels for the x and y axis .

What features of the numerical problems lead to performance : What features of both the numerical problems and vector computers lead to this high performance?

The file you should encode the contents of the array : When you get to the end of the file you should encode the contents of the array with a Vigenère cipher using the keyword CRYPTOGRAM, then print it out.

How well you show that the flow chart represents : In cosmology the behavior of space through time is given by a function called the scale factor = r(t).

What case can be made that flexible rates lead more : What case can be made that flexible exchange rates reduce the flow of long-term foreign direct investment? What case can be made that flexible rates might.

User Account

All Pages