Description
i need good paper by 1.30pm
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Thank you for the opportunity to help you with your question!
Please let me know if you need any clarification. I'm always happy to answer your questions.Completion Status:
100%
Review
Review
Anonymous
Super useful! Studypool never disappoints.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
5 pages
Working Bibliography
Benson, J. & Brown, M. (2011). Generations at work: Are there differences and do they The article tries to fill a gap by a ...
Working Bibliography
Benson, J. & Brown, M. (2011). Generations at work: Are there differences and do they The article tries to fill a gap by addressing a question which ...
49 pages
BUSINESS AND FINANCE EXAMPLE PROBLEMS
1. Your corporation has the following cash flows: Operating income $250,000 Interest received ...
BUSINESS AND FINANCE EXAMPLE PROBLEMS
1. Your corporation has the following cash flows: Operating income $250,000 Interest received 10,000 Interest paid 5,000 Dividends received 20,000 Dividends paid 50,000
WEEK 4 ASSIGNMENT--NEW MEDIA INTERACTIVITY - DUE 4/8
Week 4 Assignment--New Media Interactivity - Due 4/8InstructionsAfter studying the assigned reading 21st Century Communica ...
WEEK 4 ASSIGNMENT--NEW MEDIA INTERACTIVITY - DUE 4/8
Week 4 Assignment--New Media Interactivity - Due 4/8InstructionsAfter studying the assigned reading 21st Century Communication: A Reference Handbook: Chapter 54: Traditional and New Media, and then reading "The Impact of New Media on Inter cultural Communication in Global Context" complete the following assignment by synthesizing the readings. Considering the statement “technologies are simply tools” write a short essay that incorporates answers to the following prompts: A) Explain how that statement relates to the key words describing new media: "manipulate, converge, and instant." B) How does the concept of intercultural impact of new media increase the complexity of the statement? You should especially consider the new experiences, for human beings that the convergences of new media and globalization bring about.Support your responses with research from the Learning Resources. Use APA in-text citations where necessary and cite any outside sources. Create an APA Reference List or Bibliography at the end of the document.Submit your responses in the file submission area for this assignment. If you choose to “add a file” by attaching a MSWord or PDF document, please also copy and paste your response into the comments area.
C 803 Daemen College Data Analysis Task Feedback
Superstore Sales Analysis Part 1 GuidePlease send me the two different part in different excel and word document. Thank yo ...
C 803 Daemen College Data Analysis Task Feedback
Superstore Sales Analysis Part 1 GuidePlease send me the two different part in different excel and word document. Thank youWelcome! We've just poached you from the Superfone sales analytics team to work for us, here at SuperSTORE. And we have some Superstore sales for you to analyze! Our data includes nearly 10,000 orders with quite a few columns of information.You'll need to do a bit of data wrangling, and then we’d like you to produce some pivot tables, visual cues, and charts, to help us get a better understanding of the top sources of our sales and profits — and any problem areas we may have.DownloadDownload the starter file:Superstore_Orders_2015-18.xlsxSetupStart by creating and naming a fresh copy of the file. Then get the worksheet of data formatted to make it easy to work with.1.Copy the file and change the file name to:Yourlastname_ Superstore.xlsx2.Open the file and format the column widths to fit the data – or slightly wider (or narrower if relevant) to make it easier to read.WranglingLet’s do a little wrangling to prepare for the analysis!1.Format the Order Date and Ship Date columns to the date format mm/dd/yyyy — as this will give us a consistent number of digits for all dates when we load the data into the database.2.Reformat the Customer Names so that they are in the format — Lastname, Firstname — together in one single column. (We do not need more columns! We just want last name first.) HINT: Create a new column and use Flash Fill to do this! Then delete the old column.3.Format the Sales to the Accounting $ format, and then set the number of decimals to two.4.Format Discount as percentages.5.Notice that our Profit amount per order often includes fractions of pennies. Let’s keep track of that while formatting it as money. So, format the Profit column to Accounting $, and set the number of decimals to four.6.Finally, sort these orders by Date rather than by Row ID.Here are two screenshots of my result:Columns A-KColumns L-UNow we’re ready to start analyzing!
AnalysisWe will begin analyzing this data by creating 5 pivot tables that will summarize the data in useful ways. Create the following new sheets to analyze our data:Sales by Customer1.Create a pivot table with the following data and formatting:a.Rows contain Customer Names.(There are 793 customers!)b.Columns needed: Sales, Quantity, Discount, Profitc.Arrange Discount so that it comes after Profit.d.Format Sum of Sales to Accounting with 2 digits.e.Change Sum of Discount to Average of Discount. Hint:f.Format Sum of Profit as Accounting, with two decimals (not four — as we don’t need that precision for this report).g.Format Average Discount to Percentages, with two decimals.h.Rename the column headings to be shorter:i.Customerii.Ordersiii.Total Salesiv.Total Profitv.Avg Discounti.Increase the column header font size to 12.j.Make the column header row taller to add white space.k.Add a title to the top row of the worksheet, and apply the Heading 1 style to that row.Your sheet should now look very much like this:2.This pivot table is long! Let’s add visual cues: Use Conditional Formatting to accomplish the following:a.Orders: Apply the Green – White color scale to this column (but not to the Grand Total row at bottom!)b.Total Sales: Apply the Green – White color scale to this column (but not to the Grand Total row at bottom!)c.Total Profit: There are some negative profit numbers, which we want to highlight in red. So apply the Green – White – Red color scale to this column (but not to the Grand Total row at bottom!).d.Avg Discount: Higher discount indicates danger. So apply the Red – White – Green color scale to this column (but not to the Grand Total row at bottom!).Your results should look very much like this:And the last rows should look very much like this:Scroll through your work, and observe the power of this fully operational pivot table!!Then on to the next pivot table!Sales by StateNow let’s build a similar pivot table to view the same data by State instead of Customer.1.Copy the Sales by Customer worksheet.2.Replace Customer with State in the pivot table.3.Update the worksheet heading and title in the tab.4.Adjust the formatting of the pivot table. (For instance, the State column heading may need to be resized to 12pt font.)5.Set up conditional formatting for Orders, Sales, and Avg Discount as they are on the Sales by Customer pivot table.Again, we can see that these conditionally formatted tables are pretty useful!Now, on to …Sales by Category (and Sub-Category)We need a chart that summarizes total sales by category. To do this, we’ll first create a pivot table and then a horizontal bar chart.1.Create a new worksheet with a heading and pivot table, formatted much like above, with the following information:a.Rows: Category, with Sub-Category below.b.Values: Salesc.Be sure to choose the Outline Report Layout, format columns, update heading names, etc.2.Now visualize the data by adding a bar chart (horizontal bar chart).a.Add the chart to the side of the pivot table, size it appropriately, apply a good chart design style.b.Give the chart a heading that matches the worksheet title and tweak design details.When done, it should look something like this. (The pivot table should look just like it, and the chart should be similar to it.)Profit by CategoryNow let’s create something similar for Profit.1.Make a copy of the above worksheet, and change it to show Profit rather than Sales.2.Adjust and update the text and formatting of the pivot table, chart, and worksheet heading as needed.Notice that some of the bars will go negative (for negative profits)! That’s actually helpful — we need to see this. (We can worry about making things more readable later. Don’t sweat it for this assignment.)Time to celebrate! That’s it for this assignment!SubmitWhen complete, submit your Excel workbook: Yourlastname_Superstore.xlsx(No screenshots or Word document required for this assignment!)Superstore Analysis PART 2 GuideWe want to glean some additional insights from our Superstore data. We need you to create a few new pivot tables and charts!Begin With …Make a copy of your completed file from the first Excel Superstore assignment.Name this new file: Yourlastname_Superstore_PART2.xlsxAdd New WorksheetsAdd the following new worksheets. Format them as you did the others.Sales & Profit by RegionCreate a pivot table and bar chart:Rows with regionsDisplaying Total Sales and Total ProfitUsing the clustered bar chart to display both Sales and ProfitSales & Profit by StateCreate a pivot table:Rows in a hierarchy, with States organized under RegionDisplaying Total Sales and Total ProfitUsing conditional highlighting to indicate:ohighest salesolowest and highest profit
Sales & Profit by QuarterCreate a pivot table and line chart similar to this:Sales by MonthCreate a pivot table and line chart similar to this:SubmitWhen complete, submit your Excel workbook: Yourlastname_Superstore_PART2.xlsx(No screenshots or Word document required for this assignment!)Discussion: Superstore Analysis Parts 1 & 2Use this discussion board to share tips, recommendations, and discussion regarding the projects in this module. To foster dialogue, I'm requiring everyone to post something -- whether a question, a reflection, or feedback to other users.Here are recommended ideas to prompt your contributions:Have you gotten stuck? You're undoubtedly not alone. Please describe your problem and include screenshots if relevant.Can you provide help in response to another student's question? If so, please do!Did you discover any helpful tips in this process? Please share it. Provide relevant screenshots, links, etc.
7 pages
Communication Theory
Correspondence is a critical part and concern in various associations. With various associations having such a differing w ...
Communication Theory
Correspondence is a critical part and concern in various associations. With various associations having such a differing workforce, conveying has an effect on how good representatives, patient and relatives interface together. Various correspondence issues emerge because there are various workers from distinctive societies and diverse sexes
5 pages
Management Finance.edited
IMPACT OF COVID-19 ON THE PERFORMANCE OF OCCIDENTAL PETROLEUM Since the outbreak of the current pandemic of Covid-19, the ...
Management Finance.edited
IMPACT OF COVID-19 ON THE PERFORMANCE OF OCCIDENTAL PETROLEUM Since the outbreak of the current pandemic of Covid-19, the world economic, social, and
Similar Content
Persuasive speaking, psychology homework help
Persuasive speaking. Need 10 slides Power Point and One page Outline. look at the documents below, follow the requirement ...
The Global Trends Report and The Fundamental Structural Forces Essay
This paper has two parts. First, please choose one of the five future scenarios in the Global Trends 2040: A More Conteste...
New York University Lululemon Case Simulation Report
Learning Goal: I'm working on a management case study and need a sample draft to help me learn.
Deliverables
Students will...
Grand Canyon University Financial Leasing Memorandum
Assume the company you work for is privately held and desires to go public in the next few years. To prepare for the initi...
MGT 402 SEU Entrepreneurship & Small Business Worksheet
المملكة العربية السعودية
وزارة التعليم
الجامعة السعودية...
IT Applications Hardware and Software Components
See attachment Appendix CDiscuss with your assigned team members the following IT applications, hardware, and softwar...
Deliverable 07 Data
...
Nasdaq Editted
In the United States, we have the major stock market exchange such as the New York Stock Exchange (NYSE) and the National ...
Program management class lectures_135484362-The-Best-of-Project-Management-Software
uploads/services/161584/Program management class lectures_135484362-The-Best-of-Project-Management-Software.pdf...
Related Tags
Book Guides
Cat on a Hot Tin Roof
by Tennessee Williams
The Fault in Our Stars
by John Green
Sense And Sensibility
by Jane Austen
2001 A Space Odyssey
by Arthur Clarke
Into Thin Air
by Jon Krakauer
The Adventures of Huckleberry Finn
by Mark Twain
Heart of Darkness
by Joseph Conrad
A Separate Peace
by John Knowles
The Sixth Extinction An Unnatural History
by Elizabeth Kolbert
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
5 pages
Working Bibliography
Benson, J. & Brown, M. (2011). Generations at work: Are there differences and do they The article tries to fill a gap by a ...
Working Bibliography
Benson, J. & Brown, M. (2011). Generations at work: Are there differences and do they The article tries to fill a gap by addressing a question which ...
49 pages
BUSINESS AND FINANCE EXAMPLE PROBLEMS
1. Your corporation has the following cash flows: Operating income $250,000 Interest received ...
BUSINESS AND FINANCE EXAMPLE PROBLEMS
1. Your corporation has the following cash flows: Operating income $250,000 Interest received 10,000 Interest paid 5,000 Dividends received 20,000 Dividends paid 50,000
WEEK 4 ASSIGNMENT--NEW MEDIA INTERACTIVITY - DUE 4/8
Week 4 Assignment--New Media Interactivity - Due 4/8InstructionsAfter studying the assigned reading 21st Century Communica ...
WEEK 4 ASSIGNMENT--NEW MEDIA INTERACTIVITY - DUE 4/8
Week 4 Assignment--New Media Interactivity - Due 4/8InstructionsAfter studying the assigned reading 21st Century Communication: A Reference Handbook: Chapter 54: Traditional and New Media, and then reading "The Impact of New Media on Inter cultural Communication in Global Context" complete the following assignment by synthesizing the readings. Considering the statement “technologies are simply tools” write a short essay that incorporates answers to the following prompts: A) Explain how that statement relates to the key words describing new media: "manipulate, converge, and instant." B) How does the concept of intercultural impact of new media increase the complexity of the statement? You should especially consider the new experiences, for human beings that the convergences of new media and globalization bring about.Support your responses with research from the Learning Resources. Use APA in-text citations where necessary and cite any outside sources. Create an APA Reference List or Bibliography at the end of the document.Submit your responses in the file submission area for this assignment. If you choose to “add a file” by attaching a MSWord or PDF document, please also copy and paste your response into the comments area.
C 803 Daemen College Data Analysis Task Feedback
Superstore Sales Analysis Part 1 GuidePlease send me the two different part in different excel and word document. Thank yo ...
C 803 Daemen College Data Analysis Task Feedback
Superstore Sales Analysis Part 1 GuidePlease send me the two different part in different excel and word document. Thank youWelcome! We've just poached you from the Superfone sales analytics team to work for us, here at SuperSTORE. And we have some Superstore sales for you to analyze! Our data includes nearly 10,000 orders with quite a few columns of information.You'll need to do a bit of data wrangling, and then we’d like you to produce some pivot tables, visual cues, and charts, to help us get a better understanding of the top sources of our sales and profits — and any problem areas we may have.DownloadDownload the starter file:Superstore_Orders_2015-18.xlsxSetupStart by creating and naming a fresh copy of the file. Then get the worksheet of data formatted to make it easy to work with.1.Copy the file and change the file name to:Yourlastname_ Superstore.xlsx2.Open the file and format the column widths to fit the data – or slightly wider (or narrower if relevant) to make it easier to read.WranglingLet’s do a little wrangling to prepare for the analysis!1.Format the Order Date and Ship Date columns to the date format mm/dd/yyyy — as this will give us a consistent number of digits for all dates when we load the data into the database.2.Reformat the Customer Names so that they are in the format — Lastname, Firstname — together in one single column. (We do not need more columns! We just want last name first.) HINT: Create a new column and use Flash Fill to do this! Then delete the old column.3.Format the Sales to the Accounting $ format, and then set the number of decimals to two.4.Format Discount as percentages.5.Notice that our Profit amount per order often includes fractions of pennies. Let’s keep track of that while formatting it as money. So, format the Profit column to Accounting $, and set the number of decimals to four.6.Finally, sort these orders by Date rather than by Row ID.Here are two screenshots of my result:Columns A-KColumns L-UNow we’re ready to start analyzing!
AnalysisWe will begin analyzing this data by creating 5 pivot tables that will summarize the data in useful ways. Create the following new sheets to analyze our data:Sales by Customer1.Create a pivot table with the following data and formatting:a.Rows contain Customer Names.(There are 793 customers!)b.Columns needed: Sales, Quantity, Discount, Profitc.Arrange Discount so that it comes after Profit.d.Format Sum of Sales to Accounting with 2 digits.e.Change Sum of Discount to Average of Discount. Hint:f.Format Sum of Profit as Accounting, with two decimals (not four — as we don’t need that precision for this report).g.Format Average Discount to Percentages, with two decimals.h.Rename the column headings to be shorter:i.Customerii.Ordersiii.Total Salesiv.Total Profitv.Avg Discounti.Increase the column header font size to 12.j.Make the column header row taller to add white space.k.Add a title to the top row of the worksheet, and apply the Heading 1 style to that row.Your sheet should now look very much like this:2.This pivot table is long! Let’s add visual cues: Use Conditional Formatting to accomplish the following:a.Orders: Apply the Green – White color scale to this column (but not to the Grand Total row at bottom!)b.Total Sales: Apply the Green – White color scale to this column (but not to the Grand Total row at bottom!)c.Total Profit: There are some negative profit numbers, which we want to highlight in red. So apply the Green – White – Red color scale to this column (but not to the Grand Total row at bottom!).d.Avg Discount: Higher discount indicates danger. So apply the Red – White – Green color scale to this column (but not to the Grand Total row at bottom!).Your results should look very much like this:And the last rows should look very much like this:Scroll through your work, and observe the power of this fully operational pivot table!!Then on to the next pivot table!Sales by StateNow let’s build a similar pivot table to view the same data by State instead of Customer.1.Copy the Sales by Customer worksheet.2.Replace Customer with State in the pivot table.3.Update the worksheet heading and title in the tab.4.Adjust the formatting of the pivot table. (For instance, the State column heading may need to be resized to 12pt font.)5.Set up conditional formatting for Orders, Sales, and Avg Discount as they are on the Sales by Customer pivot table.Again, we can see that these conditionally formatted tables are pretty useful!Now, on to …Sales by Category (and Sub-Category)We need a chart that summarizes total sales by category. To do this, we’ll first create a pivot table and then a horizontal bar chart.1.Create a new worksheet with a heading and pivot table, formatted much like above, with the following information:a.Rows: Category, with Sub-Category below.b.Values: Salesc.Be sure to choose the Outline Report Layout, format columns, update heading names, etc.2.Now visualize the data by adding a bar chart (horizontal bar chart).a.Add the chart to the side of the pivot table, size it appropriately, apply a good chart design style.b.Give the chart a heading that matches the worksheet title and tweak design details.When done, it should look something like this. (The pivot table should look just like it, and the chart should be similar to it.)Profit by CategoryNow let’s create something similar for Profit.1.Make a copy of the above worksheet, and change it to show Profit rather than Sales.2.Adjust and update the text and formatting of the pivot table, chart, and worksheet heading as needed.Notice that some of the bars will go negative (for negative profits)! That’s actually helpful — we need to see this. (We can worry about making things more readable later. Don’t sweat it for this assignment.)Time to celebrate! That’s it for this assignment!SubmitWhen complete, submit your Excel workbook: Yourlastname_Superstore.xlsx(No screenshots or Word document required for this assignment!)Superstore Analysis PART 2 GuideWe want to glean some additional insights from our Superstore data. We need you to create a few new pivot tables and charts!Begin With …Make a copy of your completed file from the first Excel Superstore assignment.Name this new file: Yourlastname_Superstore_PART2.xlsxAdd New WorksheetsAdd the following new worksheets. Format them as you did the others.Sales & Profit by RegionCreate a pivot table and bar chart:Rows with regionsDisplaying Total Sales and Total ProfitUsing the clustered bar chart to display both Sales and ProfitSales & Profit by StateCreate a pivot table:Rows in a hierarchy, with States organized under RegionDisplaying Total Sales and Total ProfitUsing conditional highlighting to indicate:ohighest salesolowest and highest profit
Sales & Profit by QuarterCreate a pivot table and line chart similar to this:Sales by MonthCreate a pivot table and line chart similar to this:SubmitWhen complete, submit your Excel workbook: Yourlastname_Superstore_PART2.xlsx(No screenshots or Word document required for this assignment!)Discussion: Superstore Analysis Parts 1 & 2Use this discussion board to share tips, recommendations, and discussion regarding the projects in this module. To foster dialogue, I'm requiring everyone to post something -- whether a question, a reflection, or feedback to other users.Here are recommended ideas to prompt your contributions:Have you gotten stuck? You're undoubtedly not alone. Please describe your problem and include screenshots if relevant.Can you provide help in response to another student's question? If so, please do!Did you discover any helpful tips in this process? Please share it. Provide relevant screenshots, links, etc.
7 pages
Communication Theory
Correspondence is a critical part and concern in various associations. With various associations having such a differing w ...
Communication Theory
Correspondence is a critical part and concern in various associations. With various associations having such a differing workforce, conveying has an effect on how good representatives, patient and relatives interface together. Various correspondence issues emerge because there are various workers from distinctive societies and diverse sexes
5 pages
Management Finance.edited
IMPACT OF COVID-19 ON THE PERFORMANCE OF OCCIDENTAL PETROLEUM Since the outbreak of the current pandemic of Covid-19, the ...
Management Finance.edited
IMPACT OF COVID-19 ON THE PERFORMANCE OF OCCIDENTAL PETROLEUM Since the outbreak of the current pandemic of Covid-19, the world economic, social, and
Earn money selling
your Study Documents