Question: Evaluate the data fields available that you could use to conduct marketing analytics. After reviewing the data, select the questions you can ask to better

Evaluate the data fields available that you could use to conduct marketing analytics. After reviewing the data, select the questions you can ask to better understand avocado sales.

Variable Name

Description

Observation

A unique identifier for each observation. This is a primary key that is located across multiple avocado datasets. A primary key can guide the integration of data from one table to the data of another table, such as in the case of observationid.

Region

The sales geographic location

Year

The year of the observation

Month

The month of the observation

Quarter

The quarter of the observation

Type

Conventional or organic

Average Price

The average price of a single avocado

Total Volume

Total number of avocados sold

Supplier ID

A unique identifier indicating the supplier of the avocado.

1. Where are avocados being sold over certain average prices?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

2. What are the highest average prices customers are paying for a single avocado?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

3. In general, how satisfied are our current customers?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

4. What is the average price customers are paying per region?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

5. What are customers saying about our products on social media?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

6. Where are avocados being sold over certain average prices?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

7. What is the average price that customers are paying in specific geographic regions?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

8. What are our daily sales numbers?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

9. How are regions performing by volume sales?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

10. What is the company and country origin for avocados supplied to each region?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

11. What stores sell the most avocados?

(Click to select) Question can be answered with this data ,, Question cannot be answered with this data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!