+1(978)310-4246 credencewriters@gmail.com
Select Page

You should find dataset from
http://www.datasciencecentral.com/profiles/blogs/big-data-sets-available-for-free. or similiar web.
Instruction
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
organization.
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:
ï‚· 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
words.
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
APA format.
In short,
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.