1. You should provide THREE (3) insightsbased on your data sets. You will be looking for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. You should provide THREE (3) insightsbased on your data sets. You will be looking for relationships between attributes in the data set that can help you understand the company's products, customers, sales and or any other aspects. 2. You are expected to demonstrate your ability to use the following functions appropriately: Sorting, Filtering, Subtotals, IF, Countl F, Averagel F, Pivot Tables and others. 3. Your analysis may not support using all the listed functions. However, your team will be marked on the sophistication of the analysis and the appropriateness of the tools being used. 4. You and your team are expected to create some professional chart(s) for each insight to communicate the results of your analysis. The charts should help to interpret our results and conclusions. 5. For each insight, the report of your data analysis will include: a. A statement about what you are trying to discover. b. Tables summarizing the results from your analysis. c. Charts/diagrams/plots you are using to visualise the data with appropriate headings and formatting. d. Screen shots from the Excel will be acceptable if it is clearly labelled and concise. e. A brief description of what you have discovered and how the decision making people can use this information to add value to their business 1. You should provide THREE (3) insightsbased on your data sets. You will be looking for relationships between attributes in the data set that can help you understand the company's products, customers, sales and or any other aspects. 2. You are expected to demonstrate your ability to use the following functions appropriately: Sorting, Filtering, Subtotals, IF, Countl F, Averagel F, Pivot Tables and others. 3. Your analysis may not support using all the listed functions. However, your team will be marked on the sophistication of the analysis and the appropriateness of the tools being used. 4. You and your team are expected to create some professional chart(s) for each insight to communicate the results of your analysis. The charts should help to interpret our results and conclusions. 5. For each insight, the report of your data analysis will include: a. A statement about what you are trying to discover. b. Tables summarizing the results from your analysis. c. Charts/diagrams/plots you are using to visualise the data with appropriate headings and formatting. d. Screen shots from the Excel will be acceptable if it is clearly labelled and concise. e. A brief description of what you have discovered and how the decision making people can use this information to add value to their business
Expert Answer:
Answer rating: 100% (QA)
Insights from Rosetta Stone Data Insight 1 Identifying HighGrowth Markets a Objective To identify markets with the highest potential for future growth based on historical sales performance b Analysis ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Three charges are placed as shown in the figure below. A scale is provided for the distances. Match the numerical values with the appropriate force of interaction. 19=8c a. b. 9=-2C I'm 93=4...
-
Two blocks, of masses M = 2.0kg and 2M, are connected to a spring of spring constant k = 200 N/m that has one end fixed, as shown in Figure.The horizontal surface and the pulley are frictionless, and...
-
Ashton Tate, an in-charge auditor, has completed the year end physical inventory observation at a large wholesaler of automotive parts. Tate reviewed managements inventory-taking instructions before...
-
The Mann Corporation began operations in 2015.Information relating to the companys purchases of inventory and sales of products for 2015 and 2016 is presented below. Calculate the weighted-average...
-
Following is the chart of accounts of Sanchez Realty Company: Assets 111 Cash 113 Accounts Receivable 115 Supplies 117 Prepaid Insurance 124 Office Furniture Liabilities 221 Accounts Payable Owners...
-
Tyrone O'Shea is a single father of two children, and his tax liability for the year is $1,350. His employer withheld $1,100 in federal taxes, and he is eligible for the child and dependent care...
-
1. Consider the problem of returning change to a customer requiring the smallest number of coins. a. Show that the greedy algorithm given below returns the smallest number of coins for the coin set...
-
Jill purchased her principal residence on January 1, Year 4, for $300,000. On January 1, Year 6, when it was worth $250,000, she turned it into a rental house. On January 1, Year 9, after...
-
Assume that the investment possibilities are Stocks (S) and Bonds (B). Stocks have an expected return of 10% and a standard deviation of 18%. Bonds have an expected return of 4% and a standard...
-
-442-4.2.5 x= simplifies to x = 2.2 (Simplify your answer. Tyne an exact
-
Compute common-size percents for the following comparative Income statements spanning 2 years. Comparative Income Statements For Years Ended December 31 Current Yeal Sales Cost of goods sold Gross...
-
Discuss the role of cofactors and prosthetic groups in enzyme function. How do these molecules contribute to enzymatic activity, and what happens when they are deficient or absent ?
-
Smart Inc.'s stock has following returns over the past 4 years: 7 percent, 12 percent, -8 percent, and 20 percent. What was the arithmetic average return on the company's stock over this four-year...
-
Evaluate the following postfix expression: 356 13 182/+
-
The Cholesterol Level data sets give cholesterol levels of heart attack patients. Cholesterol measures are taken 2, 4, and 14 days aft er a patient has suffered a heart attack. Is there a significant...
-
Explain the theory behind the dividends valuation approach. Why are dividends value-relevant to common equity shareholders?
-
iRobot designs and manufactures robots for consumer, commercial, and military use. For the fiscal year ended January 2, 2016, the company reported the following on its balance sheet and income...
-
Firms invest in marketable securities for a variety of reasons. One of the most common reasons is to temporarily invest excess cash. Securities that qualify for the available-for-sale reporting...
-
Recently you read an article regarding a new product introduced late last year by 5G Inc., a consumer products company. The article's author, although praising \(5 \mathrm{G}\) Inc. for providing the...
-
The Thurston Company's current year income statement contains the following data: Thurston's comparative balance sheets show the following data (accounts payable relate to merchandise purchases):...
-
Burger King announced it would phase abused chicken out of its supply chain by 2024. The new standards include the requiring of higher-welfare strains of chickens, a reduction in the stocking density...
Study smarter with the SolutionInn App