You should find dataset from
http://www.datasciencecentral.com/profiles/blogs/big-data-sets-available-for-free. or similiar web.
Many companies and placement agencies require candidates to have knowledge about Excel as part of their recruitment
process. Knowledge of Excel is useful in several fields in various industries, especially data analysis. Read the assigned
chapter for the week. Come up with a use case for the concepts covered using real-world data for a business or
In the discussion forum, post a brief explanation of your data, the business or organization, and the use case in the
appropriate forum of the message board. You cannot use the same business or dataset as one of your peers. If you are
uncertain of the data or organization to use for this assignment, use the discussion forum to brainstorm with your peers.
Once you have chosen a data set and organization, create an Excel file in which you apply functions to demonstrate the use
case. On a separate sheet in the Excel file, write a brief overview and summary in which you:
ï‚· Provide an overview of your data, business/organization, and use case
ï‚· Analyze the data and give reasoning of why you think it is useful to the business or organization.
ï‚· Articulate what Excel functions you have used and apply it to the dataset to demonstrate it.
Above is the instruction, and we need to complete 7 discussions with the same instruction above, only each with different
excel functions below:
Intersession Topic Functions
1 Text Functions
2 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
3 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions
4 The OFFSET Function
5 Summarizing Data by Using Histograms and Pareto Charts
6 Consolidating Data
7 Charting Tricks
Please upload 7 excel files for the given 7 topicâ€™s functions, and 7 word documents come along.
The data set you found should be the same one, please cite your sources as well.
The data set you found should be from real-world data, and from a real world industry.
After you done the 7 discussions above, please include an introduction of the overall. Each discussion should be about 300
For each function, there are the tutorial videos (exactly what we should do):
ïƒ˜ Inter session 1 – Excel Text Functions – LEFT RIGHT MID FIND Tutor ial
ïƒ˜ Inter session 2 – Excel COUNTIF Function Tutor ial: Excel 2016 Range Cr iter ia Gr eater Than
ïƒ˜ Inter session 3 – COUNTIF, SUMIF, or AVERAGEIF
ïƒ˜ Inter session 4 – Excel Basics – Video Tutor ial How To Use Offset For mulas
ïƒ˜ Inter session 5 – How to Cr eate A Par eto Char t Like A Pr o in Excel
ïƒ˜ Inter session 6 – Consolidating Data fr om Multiple Excel Wor ksheets By Position
ïƒ˜ Inter session 7 – How To… Plot Multiple Data Sets on the Same Char t in Excel
Be mindful of your choice of dataset, we need the dataset that could fulfill all the functions above (the 7 topics),
And after you finish data processing of 7 topics, and finish the discussions of 7 topics,
Combine those 7 discussions with visualizations to form to a report:
The report should have
Provide an introduction to your overall project
Give a rationale and explanation for the datasets you have chosen
Include at least two tables demonstrating your data and analysis
Create at least one graphic to visualize the data and your analysis
Explain how you have analyzed the data uzing at least 5 Excel functions
Give a thorough analysis of the data and it’s implications not only for the organization but also the industry in
which the organization operates.
Offer any closing thoughts about the data and the overall project
Your report should be 8-10 pages, not including cover and reference pages. Provide at least 5 outside references and use
We are using one dataset (please make sure it is fit all functions), to do all 7 topic function processings,
Then write eachâ€™s instruction, then combine them as a formal report.
I COMPLETED THE FIRST TASK BUT IT WAS A DISASTER, PLEASE READ MY MISTAKEâ€™S FEEDBACK TO
AVOID IN THE FUTURE.
Purchase answer to see full