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. What is the correct syntax?
1 / 1 point
Correct
The correct syntax is =SUM(E2:E53). The SUM function adds the values of a range of cells. E2:E53 is the specified range.
Related Questions & Answers:
- You read an interesting article in a magazine and want to share it in the discussion forum. What should you do when posting? Select all that apply. 8.You read an interesting article in a magazine and want to share it in the discussion forum. What should you ... Read more...
- A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst’s toolkit. 8.A data analyst wants to retrieve information from a database. Select the correct tool from the data analyst’s toolkit. 1 / 1 ... Read more...
- In the following query, FROM is telling the database to filter out data from the Orders table. 5.In the following query, FROM is telling the database to filter out data from the Orders table. 1 / 1 ... Read more...
- You’ve reached the share phase of the data analysis process. It involves which of the following? Select all that apply. 5. Scenario 1 continued You’ve reached the share phase of the data analysis process. It involves which of the following? ... Read more...
- While creating data visualizations for a slideshow, a data analyst considers, “What would help a stakeholder understand this data better?” The analyst is in the analyze step of the data analysis process. 2. While creating data visualizations for a slideshow, a data analyst considers, “What would help a stakeholder understand this data ... Read more...
- What do data analysts use to label the type of data contained in each column in a spreadsheet? 2. What do data analysts use to label the type of data contained in each column in a spreadsheet? 1 / 1 ... Read more...