Market analysis worksheet

Assignment Help Other Subject

Reference no: EM132647198

Review Assignment

Data File needed for the Review Assignments: Market.xlsx

Haywood is creaing another workbook that will have market survey data on competing manufactures as well as more demographic data on potential Backspace Gear customers He wants you to add charts to his workbook that show this data graphicaly

Complete the following

1. Open the Maket workbook located in the Excel4> Review folder included with your Data iles, and then save the workbook as Market Analywás in the location specified by your Instructor

2. In the Doumentation worksheet, enter your name in cell B3 and the date in cel B4 In the Reniness Inan worksheet, enter the data values and formulas required to calculate the n the nonthly payment on a business loan of $22500., 6.2% annual interest to be repaid in 15 years. Calculate both the monthly payment and the size of the annual payment

5. In the Market Analysis worksheet, use data in the tange A4 B9 to create a pe chart in the Apply the Style 11 chart style to the pie chart, and then move the legend to the left side of the

6 In the Market Tables worksheet, creale a clustered column chart of the data in the range AS F10

7. Move the chart to the Market Analysis worksheet and then resize it to cover the range E4 13 ange Al1 C24 that shows information about compettors in the Northwest region chart. Place the data labels on the inskle end of each pie sice o show how many units each competitor sold in the Northwest region in the past five years Change the chart btle t Units Sold Apply the Style 9 chart style to the chart Add both pr im.ary majpr horizontal and vertical gridines. Change the fill color of the chart area to the Gold Accent 4 .ighter 80% theme color anite fill color of pilot area to white Move the legend to the right side of chart area.

8. In the Market Tables worksheet, use the data in the range AS.F10 to create a stacked column chart. Move the chart to the Market Analysis worksheet, and then resize it to cover the range 15124

9. Change the chart title to Total Units Sold. Format the chart with the same ill colors and gridlines you used the clustered column chart Move the legend tb the right side of the c

10. In the Market Tables worksheet, select the nonadjacent range AS FSA11F11A29 F29, and then create a combinaton chart with Total Lnis as a clustered column chart and Total Revenue as a ine chart displayed on the secondary axis

11. Move the chart the Market Analysis worksheet, and then resize it to cover te range E26 L40 the chart titke to Units Sold and Revenue Format the chart with the same fill colbrs and gridlines you used the cludered column chart. Remove the chart legend

12. Add axis titles to the primary and secondary vertical axes with the titl Tot al Units on the rimary axis and Total Revenue on the secondary axis. Rotate the secondary axis text down Change the colr of the scales and axis 5tles for the primary and secondary axes to match the rnlre nf the rkidesed rkimn chan and the line rhan

13 Change the scale of the lotal Revenue axis to go from $3,500,000 to $5,000,000 in intervals of 5250,000

14 In the Mwket Tables worksheet, select the range A23 A28,F23 F28 containing the final year evenue for each brand, and then create a Pareto chat based on this datb. Move the chart to the Market Analyss worksheet, and then resize it to cover the range A26 C40

15 Change the chart title to Market Revenue (2017) Fomat the rhan with the same fill rnn and gridlines you used the cludered column chant

16 In the Srvey Data worksheet, create a hisogram of the dstibution ol customer ages in the arge E7:ES06. Change the chart title to Age Distribution Resize the chart to cover the range 16 4 P22 in the Survey Data worksheet

17. Change the width of the histogram bins to 5 units In "be "ange CS C9?meet line sparklines based on the data in he tange B1 SF 19c" the Market Tables worksheet to show how the competitors share of the market has changed over the past live years 0 Save the wokbook, and then close it

18. In the Market Analysis worksheet, add gradient fill orange data bars to the values in the range BS:89. Set the maximum value of the data bars to 0.6.

19. In the range C5:C9, insert line sparklines based on the data in the range 81 S:F19 of the Market Tables worksheet to show how the competitors' shared the market has changed over the past five years.

20. Save the workbook, and then close it.

Attachment:- Market.rar

Reference no: EM132647198

Questions Cloud

Find effective annual interest rate of loan : You just bought a fancy TV on credit for $5,000 and the terms of the loan are: 3-year loan for with monthly (end of the month)

Discussing a workable plan to improve the emotional skills : Develop a 1,400- to 1,750-word paper discussing a workable plan to improve the emotional skills and competencies of people in one of the team member's place.

Conditions of racial and ethnic minority populations : How is the linkage between poverty and discrimination reflected in the conditions of racial and ethnic minority populations?

Applying the principles of keynesian model : Applying the principles of the Keynesian model, what specific economic policies would you propose to accomplish these goals?

Market analysis worksheet : In the Market Analysis worksheet, use data in the tange A4 B9 to create a pe chart in the Apply the Style 11 chart style to the pie chart, and then move the leg

Determine the price of your product per unit : Determine the price of your product per unit and explain in detail how you determined the price (i.e. cost base used, the pricing method)

Corporate it security audit compliance : Write a paper on HIPAA compliance law/policy and describe how to conduct IT auditing for compliance with it.

Describe five types of endpoints : Describe 5 types of Endpoints. Describe NSA's suggested data-loss response process.

Find the equivalent units of production for conversion costs : March 1, 201, Dorchester Company's beginning work in process inventory had 6,000 units. find the equivalent units of production for conversion costs

User Account

All Pages