Big Data Analytics in Business
Prices for round-shaped diamonds taken from an online trader are given in Table 1. Weight is the independent variable x and price is the dependent variable y. We will analyze this data in the computer. For Windows users, I suggest using Excel (Microsoft Office). For Mac users, I suggest using Numbers (iWork ’09). For Excel and Numbers, enter chart into the Help menu to find out how to create charts, and enter trend into the Help menu to find detailed instructions on creating and manipulating trendlines for data series.
In Excel, you can adjust the precision in the trendline equations by clicking on the trendline equation.
Table 1. Prices for round-shaped diamonds Weight (carats)
An article discussed the number of Internet search results that Web surfers typically scan before selecting one. The following table represents the results for a sample of 2369 people.
Number of Internet Search Results Scanned
A few search results
First page of search results
First two pages
First three pages
More than first three pages
Consider an example of a retail store chain that wants to optimize its products’ prices for boosting its revenue. The store chain has thousands of products over hundreds of outlets, making it a highly complex scenario. Once you identify the store chain’s objective, you find the data you need, prepare it, and go through the Data Analytics lifecycle process.
You observe different types of customers, such as ordinary customers and customers like contractors who buy in bulk. According to you, treating various types of customers differently can give you the solution. However, you don’t have enough information about it and need to discuss this with the client team.