Problem regarding the duplicate frame numbers

Assignment Help Management Theories

Reference no: EM131006996

Suppose that your Sales department at your company wants to do a "customer satisfaction survey" of 20 of your company's 76 "key accounts." Suppose, further, that your Sales Vice-President has defined a key account as a customer who purchased at least $30,000 worth of merchandise from your company in the past 90 days.

(a) Set up a spreadsheet of frame numbers for these customers with the heading: FRAME NUMBERS.

(b) Then, create a separate column to the right of these frame numbers which duplicates these frame numbers with the title: Duplicate frame numbers.

(c) Then, create a separate column to the right of these duplicate frame numbers entitled "Random number" and use the ¼RAND() function to assign random numbers to all of the frame numbers in the duplicate frame numbers column. Then, change this column format so that three decimal places appear for each random number.

(d) Sort the duplicate frame numbers and random numbers into a random order.

(e) Print the result so that the spreadsheet fits onto one page.

(f) Circle on your printout the ID number of the first 20 customers that your Sales Vice-President would call for his phone survey.

(g) Save the file as: RAND5

Reference no: EM131006996

Questions Cloud

Find the centre of mass of the solid bounded : Find the centre of mass of the solid bounded by the cone z2 = X2 + y2 and above by the sphere X2 + y2 + z2 = 2az and whose density is kz.

What is the axis and what is the density of the solid : If we want to interpret the given integral as the moment of inertia of a solid about some axis, what is the axis and what is the density of the solid?

A project''s npv increases as the wacc declines : Cyberhost Corporation's sales were $225 million last year. If sales grow at 6% per year, how large (in millions) will they be 5 years later?

What is net present value if brisbane replace current system : What Is the Year 2 cash flow if Brisbane keeps using its current system - what Is the Year 2 cash flow if Brisbane replaces current system and what is the net present value if Brisbane replaces its current system?

Problem regarding the duplicate frame numbers : (a) Set up a spreadsheet of frame numbers for these customers with the heading: FRAME NUMBERS. (b) Then, create a separate column to the right of these frame numbers which duplicates these frame numbers with the title: Duplicate frame numbers.

How do professional women overcome barriers : What barriers, if any, did you experience while pursuing positions of authority within your non-profit organization? How do professional women overcome barriers while pursuing leadership positions within non-profit organizations?

Complete those steps can speed up innovation : Imagine Dow Chemical is conducting a situational analysis. According to its sales, Dow is the second largest chemical company in the world.

When is the particle moving in the positive direction : When is the particle moving in the positive direction? (Enter your answer using interval notation.) Find the total distance traveled during the first 6 s. ft Find the acceleration at time t (in ft/s2).

What are the most significant effects on the organization : Using an example analysis of poor organization design from your own experience, what are the most significant effects on the organization? What might be the best way to make an improvement to the organizational design? What positive result would ..

User Account

All Pages