Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For VBA excel code with anchor cell and offset style. Thanks. Bins data is prespecified but not Counts,it comes from running the code. 4). Using

For VBA excel code with anchor cell and offset style. Thanks. Bins data is prespecified but not Counts,it comes from running the code.

image text in transcribed

image text in transcribed

4). Using the worksheet Data in the attached file, write a sub that will do the following a). use cell A3 as an anchor cell b). locate the cell where the word Bins is located C). declare a dynamic array (name it Bins) as a single and a dynamic array (name it Cnt) as an integer d). Count the number of bins using range properties (i.e., count, etc) e). re-dimension the array Bins to have the number of bins specified in the worksheet and determine in d) f). re-dimension the array Cnt to have the number of bins plus one g). write a sub that will count the number of times the "amount purchased" is below the first value in the Bins array and place in the first element of the array Cnt, the number of times the "amount purchased" is greater than the first value and less than or equal to the second value in the Bins array and place it in the second element of array Cnt, and so on. The last element of the array Cnt will include the number of times the "amount purchased" exceeds the last value in the Bins array h). write next to the column for the Bins, the numbers collected in the Cnt array. Note that the Cnt array has one more element than the Bins arra Your code should run for a different number of Bins and a different data set with A3 as anchor cell For the example given in the worksheet, the column for Counts will look as follows: Bins Counts 75 100 294 500 63 700 53 1000 61

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DNA Databases

Authors: Stefan Kiesbye

1st Edition

0737758910, 978-0737758917

More Books

Students also viewed these Databases questions

Question

=+ Who is the negotiation partner at company level?

Answered: 1 week ago

Question

=+Which associations exist?

Answered: 1 week ago