Big Data Analytics in Business 

Big Data Analytics in Business 

Question 1

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)















  1. The data into a spreadsheet (including the header Weight and Price).
  2. Create a scatter plot of the data. Note that the scatter plot for this data appears roughly linear.
  3. Compute the linear regression equation (trendline). The trendline will be y = ax + b for some values of a and b.
  4. Adjust the minimum/maximum values on the axes of the graph to 0.4 and 1.2 for the weight and 2000 and 6500 for the price to make the graph look nice.

Question 2 

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 

Percentage (%)

A few search results


First page of search results


First two pages


First three pages


More than first three pages


  1. Construct a bar chart and a pie chart.
  2. Which graphical method do you think is best for portraying these data?
  3. What conclusion can you reach concerning how people scan Internet search results?

Question 3

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.

  1. How would you apply the data analytics life cycle to this problem?
  2. What would business understanding look like?
  3. What would data understanding look like?

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Math homework help

Do not let math assignments discourage you from trying your best. One of our math experts can help you with math homework online. Our math tutors can help you with any level of algebra, calculus, or geometry. Ask your question to get the support you need 24/7.

Order Over WhatsApp Place an Order Online

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Similar Paper