CAN I GET STEPS ON HOW TO DO THIS PROBLEM SO I CAN DO IT MYSELF?

Investment Banking

you are an investment banker and you would like to put together a brief statistical report of the most viewed stock quotes for the day. To complete this task, you will research stock prices at WWW.nasdaq.com/quotes and create a report using the analysis ToolPak.

a) Open excel and create a new workbook. Save the workbook as e08m1Stocks_LastFirst.

b) Navigate to www.nasdaq.com/quotes/real-time.aspx and locate the five most-view stock prices for the day.

c) Type the Symbol in cell B2 and type Last Sale Price in cell 3.

d) Type the corresponding stock symbols and prices in columns B and C.

e) Load the Analysis ToolPak add-in, if necessary, as described in the chapter.

f) Use the Data Analysis command and select Descriptive Statistics. Use the following specifications:

Select the range C2:C7 as the input range.

Select or deselect the Labels in first row check box, based on the input data you selected.

Select the output range E2.

Select Summary statistics.

g) Create a footer with your name on the left side, the name of the worksheet in the middle, and the file name code on the right side.

h) Save and close the workbook, and submit based on your instructor's directions.

Quintin answered this 1169 answers Was this answer helpful Solution: The excel workbook with instructor's requirements are shown below: 9 08m 1Stocks lastFirst ads - Excel Edwin Paul C. met Page Layout Formula | Data Review View Q Te me A Share X Gabri 11 DB9Conditional formatting - AP PB - Bu AEEE St Format as Table Number Cells Editing Part ) - - A - a . - Cell Styles Clipboard G. Alignment styles Font B24 4.07 Analysis Symbol Last sales) CTI Biopharma Corp Apple Inc 141.2 Citigroup Inc 58.42 Bank of America Corporation 22.71 150 Analysis plot 10 11 o. 1 2 3 45 12 100 13 14 15 16 17 18 19 Sheet1 Ready EU + 100