4. Now that you’ve confirmed that children’s literature and feminist zines are among the most requested book genres, you review the Historical Sales dataset.
To use the template for the dataset, click the link below and select “Use Template.”
Link to template: Historical Sales
If you don’t have a Google account, you can download the CSV file directly from the attachment below.
You’re pleased to see that the dataset contains data that’s specific to children’s literature and feminist zines. This will provide you with the information you need to make data-inspired decisions. In addition, the children’s literature and feminist zines metrics will help you organize and analyze the data about each genre in order to determine if they’re likely to be profitable.
Next, you calculate the total sales over 52 weeks for feminist zines. You type =CALCULATE(E2-E53) but get an error. What is the correct syntax?
1 / 1 point
Correct
Review the section on spreadsheet functions for a refresher.
Related Questions & Answers:
- Fill in the blank: A data analyst is using data to address a large-scale problem. This type of analysis would most likely require _____. Select all that apply. 8. Fill in the blank: A data analyst is using data to address a large-scale problem. This type of analysis ... Read more...
- In spreadsheets, formulas and functions end with an equal sign (=). 1. In spreadsheets, formulas and functions end with an equal sign (=). 1 / 1 point True False ✓ CorrectIn spreadsheets, formulas ... Read more...
- Conflict is a natural part of working on a team. What are some ways to help shift a situation from problematic to productive? Select all that apply. 8. Conflict is a natural part of working on a team. What are some ways to help shift a situation ... Read more...
- Nominal qualitative data has a set order or scale. 3. Nominal qualitative data has a set order or scale. 1 / 1 point True False ✓ CorrectNominal qualitative data does not ... Read more...
- Which of the following are qualities of unreliable data? Select all that apply. 3. Which of the following are qualities of unreliable data? Select all that apply. 1 / 1 point Incomplete ✓ ... Read more...
- A data analyst adds sharing permissions to limit who can edit the data contained within a file. This is an example of what? 7. A data analyst adds sharing permissions to limit who can edit the data contained within a file. This is ... Read more...