data analytics

profileafin

 

Select an organization or publicly-traded company and locate a relevant data set (sales, revenue, etc.). Apply the concepts covered during the week (COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions) to a use case with real-world data for a business or organization.

Provide a brief explanation of your data, the business or organization, and the use case. 

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.
    • 3 years ago
    • 10
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      AppleInc.Data.xlsx