Free Essay

Busisness Analytics

In:

Submitted By stephenrickey1
Words 709
Pages 3
Unit 4 [GB513: Business Analytics]

Assignment
This assignment requires you to use Excel. There is no template for this assignment. Make sure you explain your answers and provide the regression output tables for questions 1 and 2.

Question 1 Shown below are rental and leasing revenue figures for office machinery and equipment in the United States over a seven-year period according to the U.S. Census Bureau. Use these data to run a linear regression and then forecast the rental and leasing revenue for the year 2012. Year Rental and Leasing ($ millions) 2004 5,860 2005 6,632 2006 7,125 2007 6,000 2008 4,380 2009 3,326 2010 2,642

Question 2 Suppose a researcher gathered survey data from 19 employees and asked the employees to rate their job satisfaction on a scale from 0 to 100 (with 100 being perfectly satisfied). Suppose the following data represent the results of this survey. Assume that relationship with supervisor is rated on a scale from 0 to 50 (0 represents poor relationship and 50 represents an excellent relationship), overall quality of the work environment is rated on a scale from 0 to 100 (0 represents poor work environment and 100 rep resents an excellent work environment), and opportunities for advancement is rated on a scale from 0 to 50 (0 represents no opportunities and 50 represents excellent opportunities). Answer the following questions: A) What is the regression formula? B) How reliable do you think the estimates will be based on this formula? How can you tell? C) Are there any variables that do not appear to be good predictors of Job satisfaction? How can you tell?

Unit 4 [GB513: Business Analytics]

D) If a new employee reports that her relationship with her supervisor is 40, finds the quality of the work environment to be scored at 75, works 60 hours per week and rates her opportunities for advancement to be at 30, what would you expect her job satisfaction score to be? Job satisfaction Relationship with supervisor Overall quality of work environment 65 13 79 53 43 62 18 75 84 68 72 10 64 82 46 95 82 42 73 Total hours worked per week 50 60 45 65 40 50 75 40 45 60 55 50 45 40 60 55 70 40 55 Opportunities for advancement

55 20 85 65 45 70 35 60 95 65 85 10 75 80 50 90 75 45 65

27 12 40 35 29 42 22 34 50 33 40 5 37 42 31 47 36 20 32

42 28 7 48 32 41 18 32 48 11 33 21 42 46 48 30 39 22 12

Question 3

Unit 4 [GB513: Business Analytics]

Investment analysts generally believe the interest rate on bonds is inversely related to the prime interest rate for loans; that is, bonds perform well when lending rates are down and perform poorly when interest rates are up. Can the bond rate be predicted by the prime interest rate? Use the following data to construct a scatter graph and then fit a regression line to the data. Report the regression formula and the r-squared value from the chart (right click on the line, select “Add Trendline” and select options to show these metrics). Bond Rate 5% 12 9 15 7 Prime Interest Rate 16% 6 8 4 7

Submit your Assignment to the Unit 4 Dropbox. Grading rubric Your assignment will be graded based on the following breakdown. GB513 Unit 4 Assignment Points Possible 10 Points Earned

Content 2012 forecast for rental and leasing revenue is accurate (Question 1) Correct Regression Formula (Question 2) Expected job satisfaction score (Question 2) Constructed a Scatter graph and included a regression line (Question 3). Analysis Appropriate analysis of the reliability of estimates based on this formula used and how this can be determined. (Question 2) Appropriate analysis of whether there are any variables that do not appear to be good predictors of Job

5 5 5

7

7

Unit 4 [GB513: Business Analytics]

satisfaction and how this can be determined. (Question 2) Indicated whether a bond rate could be predicted by the prime interest rate. (Question 3) Writing Skills Spelling, Grammar, and Punctuation. Total 6 50 5

Similar Documents

Premium Essay

Big Data

...O C T O B E R 2 0 11 m c k i n s e y g l o b a l i n s t i t u t e Are you ready for the era of ‘big data’? Brad Brown, Michael Chui, and James Manyika Radical customization, constant experimentation, and novel business models will be new hallmarks of competition as companies capture and analyze huge volumes of data. Here’s what you should know. The top marketing executive at a sizable US retailer recently found herself perplexed by the sales reports she was getting. A major competitor was steadily gaining market share across a range of profitable segments. Despite a counterpunch that combined online promotions with merchandizing improvements, her company kept losing ground. When the executive convened a group of senior leaders to dig into the competitor’s practices, they found that the challenge ran deeper than they had imagined. The competitor had made massive investments in its ability to collect, integrate, and analyze data from each store and every sales unit and had used this ability to run myriad real-world experiments. At the same time, it had linked this information to suppliers’ databases, making it possible to adjust prices in real time, to reorder hot-selling items automatically, and to shift items from store to store easily. By constantly testing, bundling, synthesizing, and making information instantly available across the organization— from the store floor to the CFO’s office—the rival company had become a different, far nimbler type of business...

Words: 3952 - Pages: 16

Premium Essay

Bizintel

...of my company, I am not familiar with the names or metrics used to evaluate important data, but I do know from experience and part of my job function, reports and data gathered are used to make judgments and decisions about new products and constant improvements for existing services we currently provide. Surveys are completed by our travel partners and guests, and even employees. We compile reports and present them to management electronically. Our research, experience, and use of different applications, along with our IT departments, helps management and executives determine which direction to move forward. Feedback from our travel partners and guests are both direct and indirect. Upon learning about programs such as Google Analytics, the importance of webpage layout, the amount of time spent on our site, as well, as how often individuals contact our chat system and sales automation for assistance with our product gives insight to “how we are doing” as a company. Constant looping and revisiting certain pages...

Words: 526 - Pages: 3

Premium Essay

Big Data

...volume, which is the quantity of data. The second is Variety, which the type of Data. The third is velocity, which is the speed of the data is gathered. The fourth one Variability, which is inconsistency of data can hamper processes to manage it. The final one is Veracity, which is the quality of data captured can vary. These data sets are growing rapidly mainly because they are gathered at a fairly cheap. The world's technological per-capita are doubling every 40 months. Business intelligence with data with high information density to look for trends. Big Data also increased information management specialist. Some of the largest companies like IBM and Microsoft spent over 15 billion dollars on software firms which specialize in data analytics. Governments use big data because it's efficient in terms of productivity and innovation. While gathering big data is a big benefit there are also some issues that need to brought up. Some policies involving privacy, security, and liability. Companies would need to put the right people to manage and use this data efficiently. Accessibility is also crucial because most likely there will need to be third parties included and incentives put in place to enable...

Words: 293 - Pages: 2

Premium Essay

Business It World

...Date: 04-19-2015 The New Frontier: Data Analytics (Course title: Info System Decision Making) Professor: Clifton Howell Student: Deep Ajabani Data analysis is the process of finding the right data to answer your question, understanding the processes underlying the data, discovering the important patterns in the data, and then communicating your results to have the biggest possible impact. Analytics have been used in business since the management exercises were put into place by Frederick Winslow Taylor in the late 19th century. Henry Ford measured the time of each component in his newly established assembly line. But analytics began to command more attention in the late 1960s when computers were used in decision support systems. Since then, analytics have changed and formed with the development of enterprise resource planning (ERP) systems, data warehouses, and a large number of other software tools and processes. In later years the business analytics have exploded with the introduction to computers. This change has brought analytics to a whole new level and has made the possibilities endless. As far as analytics has come in history, and what the current field of analytics is today many people would never think that analytics started in the early 1900s with Mr. Ford. We are going to have a look on Big Data Analytics. Let’s have a look on advantages of big data analytics. It helps marketing companies build models based on historical data to predict...

Words: 1537 - Pages: 7

Free Essay

Internet of Things (Iot)

...Definition IoT is one of the fastest growing technologies in computing. It is an environment where people, animals, or objects are presented with unique identifiers and the ability to transfer data over a network (Rouse, 2014). It has emerged from combining wireless technologies, micro-electromechanical systems, and the internet (Rouse, 2014). See Figure 1. These wireless technologies are equipped with, or connected to a smart device allowing data collection and communication through the internet (Caron, Bosua, Maynard, & Ahmad, 2016). Figure 1. IoT Ecosystem (Medici, 2015) Benefits * Tracking behavior for real-time marketing (Borne, 2014). * Enhanced situational awareness (Borne, 2014). * Sensor-driven decision analytics (Borne, 2014). * Process optimization (Borne, 2014). * Optimized resource consumption (Borne, 2014). * Instantaneous control and response in complex autonomous systems (Borne, 2014). * Increase operational efficiency, power new business models, and improve quality of life (Harrell, 2015). * Provide an accurate analysis of customer data (Medici, 2015). Some Applications of IoF Business intelligence (BI). “The BI application ensures the analysis and measurement of the consumer’s thoughts, behaviors, relationships, buying attitudes, choices, and many more parameters that form the backbone of effective strategy building, business operations management, customer relationship management, and other business operations” ...

Words: 863 - Pages: 4

Premium Essay

Big Data Analytics

...companies in every industry are using analytics to replace intuition and guesswork in their decision-making. As a result, managers are collecting and analyzing enormous data sets to discover new patterns and insights and running controlled experiments to test hypotheses. This course prepares students to understand structured data and business analytics and become leaders in these areas in business organizations. This course teaches the scientific process of transforming data into insights for making better business decisions. It covers the methodologies, algorithms, issues, and challenges related to analyzing business data. It will illustrate the processes of analytics by allowing students to apply business analytics algorithms and methodologies to real-world business datasets from finance, marketing, and operations. The use of real-world examples and cases places business analytics techniques in context and teaches students how to avoid the common pitfalls, emphasizing the importance of applying proper business analytics techniques. In addition to cases, this course features hands-on experiences with data collection using Python programs and analytics software such as SAS Enterprise Guide. Throughout the semester, each team works to frame a variety of business issues as an analytics problem, analyze data provided by the company, and generate applicable business insights as a secondary objective, while also learning essential business analytics techniques. Students benefit...

Words: 501 - Pages: 3

Premium Essay

Disruptive Innovation: a New Era of Crowdsourced Data Analytics!

...Disruptive Innovation: A new era of Crowdsourced Data Analytics! Abstract: The existing business paradigm of data analytics is set for a transformation. Today, companies are experimenting to replicate the “Outsourced data analytics” model to “Crowdsourced data analytics”. Companies like Kaggle, Crowdanalytix and others are hitting the headlines of top analytics blogs across the globe. The reason is that the new business model promises a drastic decrease in the cost of analytics for companies long with the flexibility to get the problem solved anytime with much less effort. In short, it’s not just crowdsourcing that is the novelty of the concept, but the manner in which it is put to use that steals the show. Abstract: The existing business paradigm of data analytics is set for a transformation. Today, companies are experimenting to replicate the “Outsourced data analytics” model to “Crowdsourced data analytics”. Companies like Kaggle, Crowdanalytix and others are hitting the headlines of top analytics blogs across the globe. The reason is that the new business model promises a drastic decrease in the cost of analytics for companies long with the flexibility to get the problem solved anytime with much less effort. In short, it’s not just crowdsourcing that is the novelty of the concept, but the manner in which it is put to use that steals the show. General Management General Management MBA Core, 2nd Year MBA Core, 2nd Year Ayush Malhotra NMIMS,Mumbai Ayush Malhotra ...

Words: 1574 - Pages: 7

Premium Essay

Electives

...Spring 2016 | Elective | FIN | FIN7503 | EQUITIES | Spring 2016 | Elective | FIN | FIN7504 | RISK MANAGEMENT | Spring 2016 | Elective | FIN | FIN7511 | CORP FIN I:RASNG CAP | Spring 2016 | Elective | FIN | FIN7513 | FIXED INCOME | Spring 2016 | Elective | FIN | FIN7516 | CORP FIN II:EVAL OPP | Spring 2016 | Elective | FIN | FIN7517 | FIN & VAL SUSTNBLTY | Spring 2016 | Elective | FIN | FIN7518 | Managing Portfolios | Spring 2016 | Elective | FIN | FIN7565 | RE INV FUNDAMENTALS | Spring 2016 | Elective | FIN | FIN7572 | BABSON COLLEGE FUND | Spring 2016 | Elective | FIN | FIN7573 | INVESTMENT BANKING | Spring 2016 | Elective | FIN | FIN7578 | RE DEVELOPMENT | Spring 2016 | Elective | MATH | QTM7571 | Bus Intel, Analytics, Visualization | Spring 2016 | Elective | MATH | QTM9515...

Words: 422 - Pages: 2

Free Essay

Decision Making

...become an analytic competitor. Questions as to what are the sources of Decision Making to an analytic competitor will also be discussed. A discussion on how influential quantitative modeling is and its utility in business decision making will be summarized. Finally, a Christian view that presents an ethical perspective on quantitative modeling and decision making will be presented. In an ever increasing global environment, maintaining a competitive advantage can be sustained through quantitative modeling, which can make a company a viable analytic competitor. How Can a Company Become and Be an Analytics Competitor Competitors make it increasingly more difficult to maintain a strategic competitive advantage when exclusive technologies, products and services can be duplicated (Davenport, Cohen & Jacobson, 2005). Organizations are now framing their strategies to accomplish optimization of “key business processes”: serving optimal customers, optimize supply chains, and understand and create optimal financial performance (Davenport, et al., 2005, p. 1). Optimization strategies demand that organizations now gather extensive data and perform extensive analysis that will guide executives in the decision-making process. The data and the analysis must be specific to the issues. In other words, they must relate in order to be useful in decision-making for the firm. In order to benefit from this competitive advantage companies also have to possess the analytic capabilities...

Words: 1870 - Pages: 8

Premium Essay

Assignment 1 Week 2

...The New Frontier: Data Analytics Phylicia Marie Phillips Professor Progress Mtshali, Ph. D. Information Systems Decision-Making April 17, 2016 In the past, analytics was reserved for back-room debates by data geeks producing monthly reports on how things are going. Today, analytics make a difference in how a company does business, day to day, and even minute by minute; more specifically how Walmart does business. As many know, Walmart is an American based multinational retail corporation that operates a chain of hypermarkets, grocery stores and discount stores. With over eleven thousand stores and clubs in 27 countries, information technology and data analytics play a major role in Walmart’s survival and helps maintain its competitive advantage. Data Analytics Overview The business intelligence and analytic technologies and applications currently adopted in industry can be considered as BI&A 1.0, where data are mostly structured, collected by companies through various legacy systems, and often stored in commercial relational database management systems (Bottles and Begoli, 2014). The analytical techniques most commonly used in these systems, popularized in the 1990s, are mainly grounded in statistical methods developed in the 1970s and data mining techniques developed in the 1980s (Chiang, 2012). The digitalization of information has created more data and the development of cloud computing, and faster and faster computers has made the increased data more accessible...

Words: 1438 - Pages: 6

Premium Essay

Brief Overview of Business Intelligence and How Walmart Uses It

...biggest retailer in the world and handles more than one million customer transactions every hour and generates more than 2.5 petabytes of data storage (Venkatraman & Brooks, 2012). To put this into perspective, this data is equivalent to 167 times the number of books in America’s Library of Congress (Venkatraman & Brooks, 2012). So how can Wal-Mart use this massive amount of data and what useful information can this data provide? This paper will provide a brief overview of the importance of Business Intelligence (BI) and how the largest retailer in world, Walmart, is using it. BI platforms help management to truly understand its customer base and deliver individualized products and services (Brannon, 2010). When BI tools and analytics are used effectively, managers and decision makers can yield an all-encompassing view of the company, its position in the market, and its potential and perspectives (Albescu, and Pugna 2014). BI is best explained as a systematic process not found in a magazine, online or in a knowledge database. An organization that doesn’t have a viable BI capacity is making decisions without key information in this competitive market (Thomas, 2001). Walmart has more customer connections than any retailer in the world, from online activity to in-store purchases, and even social mentions (300,000 social mentions per week) (SAS Institute Inc.). Due to the abundance of information requiring analysis, Walmart created Walmart Labs after the company took...

Words: 867 - Pages: 4

Premium Essay

Cognos Ibm

...Chapter 12 Enhancing Decision Making Case 2: IBM and Cognos: Business Intelligence and Analytics for Improved Decision Making Tags: business decision making; business intelligence software; decision support systems; management reporting systems; executive dashboards; mobile delivery platforms. Summary In this video from the National Association of Broadcasters (NAB), Dan Fulwiler and Steve Segalewitz from IBM, discuss how understanding your online data more clearly can improve decision-making. Video demonstration of IBM/Cognos BI software applications. In the accelerating media industry, discovering relevant business insights within the chaos of available information can lead to substantial competitive advantage. IBM Business Intelligence and Analytics is designed to integrate all data providers and in-house sources to reveal timely and actionable business insights. The software collects, connects and leverages information from consumers to suppliers. L= 5:06 URL: http://www.youtube.com/watch?v=NI59ZgyQqBc Case IBM has been known for most of its recent history as the world's largest computer company. With over 388,000 employees worldwide, IBM is the largest and most profitable information technology employer in the world. It is still selling computers today, and is still one of the biggest computer companies in the world, and it has also been known to produce very efficient computers as well. IBM holds more patents than any other U.S. based technology company...

Words: 760 - Pages: 4

Premium Essay

Project Management

...May 1, 2012 To: The Star plus Manufacturing Inc., Executive Members, Chief Executive Officer and All Others that this may concern: On April 24, 2012 the executive consulting offices of Hanns-G LLC, Have continued their investigation and Data Analyzing of the current business processes that have concurrently been in progress at Star plus Manufacturing Inc. Through our Time Spend at Star plus manufacturing Inc., we have conducted the following Business Analytics including but not limited too; Analyzing Qualitative Data, Analytics, Business Intelligence, Test and Learn, Business Processes, Statistics and Customer Dynamics. While Analyzing Qualitative Data; we have conducted Open-ended Questions, accepted written comments on questionnaires in order to generate Single word opinions, Brief Outlooks on company environment. We have also found some finding though daily business observations. During our Analytics practices, we have been able to develop optimal or realistic decision recommendations based on insights derived through the application of statistical models and analysis against existing and/or simulated future data. Business intelligence used a well-established process in guiding organizational change through using Computer-Based Techniques to identify, extract and analyze business data, such as Sales revenue by individual departments and products by each ones associated Costs and Income. Test and Learn methods in order to define the impact that, current strategies are...

Words: 521 - Pages: 3

Premium Essay

Business Analytics

...Introduction Sprint has nearly 54 million customers and offers a host of products for consumers, businesses and government. The company recently began using analytics tools to try to make sense of the mountains of data created by Sprint network users on a daily basis. With approximately 70,000 employees worldwide and nearly $27 billion in annual revenues, Sprint is widely recognized for developing, engineering and deploying state-of-the-art network technologies, including the United States' first nationwide all-digital, fiber-optic network and an award-winning Tier 1 Internet backbone. Sprint provides local voice and data services in 18 states and operates the largest 100-percent digital, nationwide wireless network in the United States. The decision to focus our project on Sprint was based on a couple of factors. Sprint is currently the 3rd largest telecom operator in USA and with the recent take over by SoftBank the prospects to grow look promising. This provides a clear opportunity to help the business grow using analytics. Secondly because of our connections in the company we were able to get more information on Sprint’s analytics strategy and future plans. Recommendations Sprint Telecom is part of an industry, which is one of the largest providers of data in the world. Sprint’s initial big data steps have been in the right direction. They have successfully used their current data sets for quick profits and short-term results. It is now time to take the jump...

Words: 652 - Pages: 3

Premium Essay

Management 303 Swot Analysis

...I. Organization History SAS Institute Inc. - (Statistical Analysis System) is a software company that has been leading IT analysis since 1976. The company was started on the campus of North Carolina State University when two facility members (Jim Goodnight and John Sall), used grants provided by the United States Department of Agriculture to analyze vast amounts of agricultural data. At the time there was a need for computerized statistics programs, the grants provided allowed Goodnight, Sall and a consortium of eight land-grant universities to create the programs needed. When the grant funding came to a halt in 1972, the group of statisticians agreed to chip in $5,000 apiece each year to keep the project running. The analytical software was licensed by pharmaceutical companies, insurance companies, banks, and also by the academic community that had given birth to the project ("SAS Company Stats," n.d.). With a growing customer base that already numbered close to 100 academic, government and corporate entities, it was evident that success as an independent operation was possible. Goodnight, Sall and two other facility members decided to leave NCSU and develop SAS Institute Inc. - – a private company "devoted to the maintenance and further development of statistical analysis systems." The Company’s mission is to deliver solutions that drive innovation and improve performance ("SAS Company Stats," n.d.). II. Organizational Strengths and Weaknesses A. First organizational...

Words: 1965 - Pages: 8