Big Data Analytics in Business Question 1 Prices for round-shaped

 

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) 

Weights

Price 

0.5

2790

0.6

3191

0.7

3694

0.8

4154

0.9

5018

1.0

5898

  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 

23

First page of search results 

39

First two pages 

19

First three pages

9

More than first three pages

19

  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? 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

For this assignment, review the article: Abomhara, M., & Koien,

 For this assignment, review the article: Abomhara, M.,  & Koien, G.M. (2015). Cyber security and the internet of things:  Vulnerabilities, threats, intruders, and attacks. Journal of Cyber Security, 4, 65-88. Doi: 10.13052/jcsm2245-1439.414 and evaluate it in 3 pages (800 words), using your own words, by addressing the following:  What did

Select any example of a visualization or infographic, maybe your

Select any example of a visualization or infographic, maybe your own work or that of others. The task is to undertake a deep, detailed ‘forensic’ like assessment of the design choices made across each of the five layers of the chosen visualization’s anatomy. In each case, your assessment is only

Some observers express concern about high reelection rates for incumbent

Some observers express concern about high reelection rates for incumbent members of Congress and have advocated for term limits as a way to formally remove longtime members of Congress. Why do you think these proposals for term limits are being advanced? Are there advantages to having long-serving members of Congress in

“Captain of the Ship” Project – Bipolar Disorders

Assignment 1: “Captain of the Ship” Project – Bipolar Disorders Bipolar disorders are severe disorders of mood that include both depressive episodes and expansive, grandiose, or manic episodes. During these times, the person may engage in activities with little awareness of the consequences because of accompanying psychosis. A diagnosis of

P: Newborn I: Skin to skin contact (kangaroo care) C:

  P: Newborn  I: Skin to skin contact (kangaroo care)  C: Compared with newborn that does not experience skin to skin contact  Outcome: Does skin to skin care increase parental bonding  Time: Immediately after birth  “In newborns (patient population), how does skin to skin contact (intervention) compared with newborns that

Domestic Violence against women(Women’s health issue)

 1. Identify and discuss the women’s health issue you have chosen (see topic above) and provide statistical (quantitative) data regarding this women’s health issue.(2 pages) 2. Then provide qualitative data (women’s experiences/stories) regarding this women’s health issue.(2 pages) 3. To what extent is this an “invisible” women’s health issue? To

Topic – Should the death penalty be abolished? Critical Thinking

Topic – Should the death penalty be abolished? Critical Thinking Final paper with APA formatting – Abstract, Introduction, Main Points, Conclusion, Sources/References and Assignment Reflection (can be included after the reference page) which includes your personal evaluation of the issue, and support your position by answering the following required questions:

Developing and Managing Information Systems

Topic Developing and Managing Information Systems  You work on the IT team at a local college. You are currently on an Information Systems (IS) project that is enhancing the registration system. You have a student intern who is inexperienced and untrained. The intern has only taken one information systems course.

Instructions Using any slide share or movie making software, you

Instructions Using any slide share or movie making software, you can utilize information gathered throughout the course to create a visual travel log. This multi-media presentation will include images, video, and voice over dialogue consisting of a mix of research and original content that demonstrates your analysis of course concepts.

Choose one of the causality models in Chapter 9 of

Choose one of the causality models in Chapter 9 of the textbook and use it to explain the relationships between the risk factors associated with the leading cause of death you selected in Module Four and the outcome (death from that cause). How do Hill’s criteria for causation apply to

Wall Street Journal Strategic Management News Best Practices Dear International

 Wall Street Journal Strategic Management News Best Practices    Dear International Strategic Management Executives: In today’s business social media-driven world, the ability to make a persuasive – well thought written argument in a single paragraph is a skill that will serve you in your professional executive career. Through our academic term, you

For this assignment, Find an advertisement for a job. This

  For this assignment, Find an advertisement for a job. This can be a job you are hoping to apply for soon.  You will create an up-to-date professional ‘resume and cover letter’ for a specific current job posting.    IMPORTANT: You will need to include a link to this ad or

Skinner and other behaviorists believed that reinforcement is more effective

 Skinner and other behaviorists believed that reinforcement is more effective than punishment in shaping children’s behavior. Yet there still exists a wide variety of opinions over the best way to raise and discipline children. Compare and contrast the effective benefits of using token economies (allowances) and the use of time-out

250-450 WORDS, ANYTHING BEYOND 450 WILL RESULT IN A FAILING

250-450 WORDS, ANYTHING BEYOND 450 WILL RESULT IN A FAILING GRADE! DO NOT USE DIRECT QUOTE. EVERYTHING WILL BE IN YOUR OWN WORDS! When referring to the differences between leadership and management, the late leadership guru, Warren Bennis, said, “Managers have their eyes on the bottom line; leaders have their