1) Using the excel data file “US violent crime” which shows the violent crime rate in the US from 1960 to 2012:
(20 pts) Make a time series plot of the data
(5 pts each 25 pts total) Determine the following: Mean, Median, Standard deviation, Q1 and Q3. (25 pts)
Make a histogram of the data. Hint the year is not used, you need to determine how many years fall into each of the classes.
(7) What are your thoughts on the time series plot, i.e. trends etc.?
(8) Thoughts on the histogram i.e. shape of distribution etc.?
[Excel sheet]
| Year | Violent Crime rate |
| 1960 | 160.9 |
| 1961 | 158.1 |
| 1962 | 162.3 |
| 1963 | 168.2 |
| 1964 | 190.6 |
| 1965 | 200.2 |
| 1966 | 220.0 |
| 1967 | 253.2 |
| 1968 | 298.4 |
| 1969 | 328.7 |
| 1970 | 363.5 |
| 1971 | 396.0 |
| 1972 | 401.0 |
| 1973 | 417.4 |
| 1974 | 461.1 |
| 1975 | 487.8 |
| 1976 | 467.8 |
| 1977 | 475.9 |
| 1978 | 497.8 |
| 1979 | 548.9 |
| 1980 | 596.6 |
| 1981 | 593.5 |
| 1982 | 570.8 |
| 1983 | 538.1 |
| 1984 | 539.9 |
| 1985 | 558.1 |
| 1986 | 620.1 |
| 1987 | 612.5 |
| 1988 | 640.6 |
| 1989 | 666.9 |
| 1990 | 729.6 |
| 1991 | 758.2 |
| 1992 | 757.7 |
| 1993 | 747.1 |
| 1994 | 713.6 |
| 1995 | 684.5 |
| 1996 | 636.6 |
| 1997 | 611.0 |
| 1998 | 567.6 |
| 1999 | 523.0 |
| 2000 | 506.5 |
| 2001 | 504.5 |
| 2002 | 494.4 |
| 2003 | 475.8 |
| 2004 | 463.2 |
| 2005 | 469.0 |
| 2006 | 479.3 |
| 2007 | 471.8 |
| 2008 | 458.6 |
| 2009 | 431.9 |
| 2010 | 404.5 |
| 2011 | 387.1 |
| 2012 | 386.9 |
In: Statistics and Probability
| Average Oil Prices | |
| Year | Price per Barrel |
| 1949 | $2.54 |
| 1950 | $2.51 |
| 1951 | $2.53 |
| 1952 | $2.53 |
| 1953 | $2.68 |
| 1954 | $2.78 |
| 1955 | $2.77 |
| 1956 | $2.79 |
| 1957 | $3.09 |
| 1958 | $3.01 |
| 1959 | $2.90 |
| 1960 | $2.88 |
| 1961 | $2.89 |
| 1962 | $2.90 |
| 1963 | $2.89 |
| 1964 | $2.88 |
| 1965 | $2.86 |
| 1966 | $2.88 |
| 1967 | $2.92 |
| 1968 | $2.94 |
| 1969 | $3.09 |
| 1970 | $3.18 |
| 1971 | $3.39 |
| 1972 | $3.39 |
| 1973 | $3.89 |
| 1974 | $6.87 |
| 1975 | $7.67 |
| 1976 | $8.19 |
| 1977 | $8.57 |
| 1978 | $9.00 |
| 1979 | $12.64 |
| 1980 | $21.59 |
| 1981 | $31.77 |
| 1982 | $28.52 |
| 1983 | $26.19 |
| 1984 | $25.88 |
| 1985 | $24.09 |
| 1986 | $12.51 |
| 1987 | $15.40 |
| 1988 | $12.58 |
| 1989 | $15.86 |
| 1990 | $20.03 |
| 1991 | $16.54 |
| 1992 | $15.99 |
| 1993 | $14.25 |
| 1994 | $13.19 |
| 1995 | $14.62 |
| 1996 | $18.46 |
| 1997 | $17.23 |
| 1998 | $10.87 |
| 1999 | $15.56 |
| 2000 | $26.72 |
| 2001 | $21.84 |
| 2002 | $22.51 |
| 2003 | $27.54 |
| 2004 | $38.93 |
| 2005 | $46.47 |
| 2006 | $58.30 |
| 2007 | $64.67 |
| 2008 | $91.48 |
| 2009 | $53.48 |
| 2010 | $71.21 |
| 2011 | $87.04 |
| 2012 | $93.02 |
| 2013 | $97.91 |
| 2014 | $93.26 |
| 2015 | $48.69 |
| 2016 | $43.14 |
| 2017 | $50.88 |
a) Using the 1949 oil price and the 1969 oil price, compute the annual growth rate in oil prices during the 20 yr period. b) Compute the growth rate between 1969 & 1989 and between 1989 & 2017. c) given the price in 2017 and your growth rate between 1989 and 2017 compute the future price of oil in 2020 & 2025.
In: Finance
Thalidomide is a tranquilizer that was prescribed in the late 1950’s and early 1960’s to pregnant women, with the devastating result of over 12,000 birth defects in 48 countries before it was banned in 1962. (It was never sold in the United States.) Since then, the drug has reappeared as a possible solution to a number of medical problems. The U.S. National Institutes of Health announced on 31 October 1995 the results of a study in 30 hospitals of the effectiveness of thalidomide in healing mouth ulcers in AIDS patients. In the study, which was chaired by Dr. Jeffrey Jacobson of the Bronx Veteran Affairs Medical Center and the Mount Sinai School of Medicine in New York, it was found that 14 out of 23 patients who received thalidomide had their ulcers heal compared to 1 out of 22 patients who received a placebo. As a result of these early trial outcomes, the researchers suspended the trial giving thalidomide to all the patients in the study. THIS IS ALL THE INFO GIVEN.
In: Statistics and Probability
The global marketplace has witnessed an increased pressure from customers and competitors in manufacturing as well as service sector (Basu, 2001; George, 2002).Due to the rapidly changing global marketplace only those companies will be able to survive that will deliver products of good quality at cheaper rate and to achieve their goal companies try to improve performance by focusing on cost cutting, increasing productivity levels, quality and guaranteeing deliveries in order to satisfy customers (Raouf, 1994).
Increased global competition leads the industry to increasing efficiency by means of economies of scale and internal specialization so as to meet market conditions in terms of flexibility, delivery performance and quality (Yamashina, 1995). The changes in the present competitive business environment are characterized by profound competition on the supply side and keenindecisive in customer requirements on the demand side. These changes have left their distinctive marks on the different aspect of the manufacturing organizations (Gomes et al., 2006). With this increasing global economy, cost effective manufacturing has become a requirement to remain competitive.
To meet all the challenges organizations try to introduce different manufacturing and supply techniques. Management of organizations devotes its efforts to reduce the manufacturing costs and to improve the quality of product. To achieve this goal, different manufacturing and supplytechniques have been employed. The last quarter of the 20th century witnessed the adoption of world-class, lean and integrated manufacturing strategies that have drastically changed the way manufacturing firm’sleads to improvement of manufacturing performance (Fullerton and McWatters, 2002).
In: Operations Management
Critical Thinking
The global marketplace has witnessed an increased pressure from customers and competitors in manufacturing as well as service sector (Basu, 2001; George, 2002).Due to the rapidly changing global marketplace only those companies will be able to survive that will deliver products of good quality at cheaper rate and to achieve their goal companies try to improve performance by focusing on cost cutting, increasing productivity levels, quality and guaranteeing deliveries in order to satisfy customers (Raouf, 1994).
Increased global competition leads the industry to increasing efficiency by means of economies of scale and internal specialization so as to meet market conditions in terms of flexibility, delivery performance and quality (Yamashina, 1995). The changes in the present competitive business environment are characterized by profound competition on the supply side and keenindecisive in customer requirements on the demand side. These changes have left their distinctive marks on the different aspect of the manufacturing organizations (Gomes et al., 2006). With this increasing global economy, cost effective manufacturing has become a requirement to remain competitive.
To meet all the challenges organizations try to introduce different manufacturing and supply techniques. Management of organizations devotes its efforts to reduce the manufacturing costs and to improve the quality of product. To achieve this goal, different manufacturing and supplytechniques have been employed. The last quarter of the 20th century witnessed the adoption of world-class, lean and integrated manufacturing strategies that have drastically changed the way manufacturing firm’sleads to improvement of manufacturing performance (Fullerton and McWatters, 2002).
Consult chapter 7 of your text book or secondary available data on internet and answer the following questions.
Question:
In: Operations Management
The global marketplace has witnessed an increased pressure from customers and competitors in manufacturing as well as service sector (Basu, 2001; George, 2002).Due to the rapidly changing global marketplace only those companies will be able to survive that will deliver products of good quality at cheaper rate and to achieve their goal companies try to improve performance by focusing on cost cutting, increasing productivity levels, quality and guaranteeing deliveries in order to satisfy customers (Raouf, 1994).
Increased global competition leads the industry to increasing efficiency by means of economies of scale and internal specialization so as to meet market conditions in terms of flexibility, delivery performance and quality (Yamashina, 1995). The changes in the present competitive business environment are characterized by profound competition on the supply side and keenindecisive in customer requirements on the demand side. These changes have left their distinctive marks on the different aspect of the manufacturing organizations (Gomes et al., 2006). With this increasing global economy, cost effective manufacturing has become a requirement to remain competitive.
To meet all the challenges organizations try to introduce different manufacturing and supply techniques. Management of organizations devotes its efforts to reduce the manufacturing costs and to improve the quality of product. To achieve this goal, different manufacturing and supplytechniques have been employed. The last quarter of the 20th century witnessed the adoption of world-class, lean and integrated manufacturing strategies that have drastically changed the way manufacturing firm’sleads to improvement of manufacturing performance (Fullerton and McWatters, 2002).
Consult chapter 7 of your text book or secondary available data on internet and answer the following questions.
In: Operations Management
Based on the criteria used by the Bureau of Labor Statistics (BLS), identify each person’s status as employed, unemployed, “not in the labor force” (if not in the civilian labor force but still part of the adult population), or “not in the adult population” if not in the civilian adult population. Person Status Lorenzo is a 75-year-old professor. He teaches only one or two courses a year, but he's still pursuing an active research agenda. Neha is a 36-year-old autoworker who was just laid off by her employer. She is trying to find any kind of job to help make ends meet. Sam is a 41-year-old graphic designer who is taking 2 years off from work to care for his small daughter. Beth is a 29-year-old who lost her job as an associate producer for a radio station. After spending a few weeks out of work and interviewing for several other positions, she gave up on her job search and decided to go back to grad school. She made that decision a few months ago. Andrew is a famous novelist. He is spending the summer at his lake house in upstate New York, doing a little writing each day but mostly spending his time gardening and reading. Teresa is a 11-year-old student at West Valley Middle School. She babysits her younger sister and does other chores, so her parents give her an allowance of $20 per week. Complete the right half of the following equation to reflect the labor force participation rate reported by the BLS. Labor Force Participation Rate = According to this formula, what is the labor force participation rate of this economy of six people? 33.33% 40% 50% 60% Complete the right half of the following equation to reflect the unemployment rate reported by the BLS. Unemployment Rate = According to this formula, what is the unemployment rate of this economy of six people? 33.33% 40% 50% 60%
In: Economics
1. Suppose the industry of all farms planting beans is now in a perfectly competitive longrun equilibrium, and all farms have zero fixed cost for planting. Recent regulation in the market of fertilizers raises the price of bean fertilizer and therefore the marginal and average costs of all the farms in this industry. Note that marginal and average cost curves both experience a parallel shift up by the same amount. Please use a graphic tool to analyze the following changes to each individual farm and to the entire industry:
(a) (8 points) Set up a diagram, for both individual firms and the industry, to show the longrun equilibrium before the fertilizer shortage. Clearly mark the market price (p), individual supply (q), and the industry supply (Q).
(b) (12 points) Suppose the fertilizer shortage takes place but the price for beans has not yet adjusted accordingly (no entry or exit either). How much will each existing farm produce (mark your answer as q1 on the same graph) and how much profit or loss are they getting (make with a shaded area on your graph)?
(c) (16 points) As time goes by, will this industry experience any entry or exit? How will the price start to adjust? Explain your answer. Mark on your graph the new long-run industry supply, the new equilibrium market price (p’), the new individual supply (q’), and the new industry supply (Q’).
2. Suppose one Japanese firm and one American firm dominate the US market of widgets. They share the same cost structure: TC = 250 + 40q. The only demand for widgets is in the US and is p = 100 – Q.
(a) (16 points) If these two firms compete in quantity at the same time, what is the Cournot equilibrium output, price, profit level by each firm?
(b) (12 points) Suppose the American firm acquires the Japanese firm and therefore becomes a monopoly in this market. Calculate the monopoly’s output, price, and Lerner Index. How much is the deadweight loss due to monopoly behavior?
In: Economics
Scenario: Six months into an academic development project, the client reviews the progress and issues a stop-work order. The main issues identified during their review were: 1. There were different expectations about the complexity of graphics in course development and course materials. 2. There were different opinions about the level of marketing required (marketing a course versus marketing the whole academy, no post-course promotions, etc.) 3. There were issues with instructors. These were instances where instructors had rescheduled on multiple occasions or cancelled. 4. There were concerns about the subject matter experts. Subject matter experts had been hired outside of the budgeted amount. 5. There were concerns about the subject matter experts not providing the level of technical writing expertise required, which resulted in having to hire additional technical writers. MRG HPI addressed some of these concerns by removing the videotaping requirement during the analysis phase and removing the repeat courses that were going to be offered during the final contract year. By eliminating videotaping and repeat courses, the remaining courses to be developed and presented were stretched over the rest of the contract of 2.5 years. This mean that instead of developing and offering the 15 courses using two teams in a staggered fashion over two years, MRG HPI must reduce staff. Currently, there are three senior instructional designers, six graphic artists, three document specialists, six technical writers, three subject matter experts, and two editors assigned to the teams. MRG HPI has subject matter experts as consultants under contract. They don’t want to lose their staff, but they may have no choice but to let some go.
Questions: 1. What re the challenges faced by the Human Resource department in this scenario?
2. What can be done to retain the employees?
3. What communication strategy should be adopted to implement employee retention strategies?
In: Operations Management
Company XYZ owns a social network web site dedicated for wind surfers. They plan to launch a new online ad delivery and management service web site that will be coupled with their existing social network platform. The online ad management service will enable them to accept online orders for online ads from advertisers. The system will also deliver the ads to the main social network site. The ads will be displayed on the social network site but the content of the ads (the images and/or text objects containing the ad message) will be served by the new web site server. The company forecasts that the web site will receive an average of 10,000 visits from potential or current advertisers and 600 online ad purchase orders per week. They expect to have 30,000 registered online advertisers during the first month of the launch of the web site. Company XYZ dedicate a separate server and database for the new online service. The users of the ad management site and the users of the social network will be managed separately. The data of the two groups will be stored on separate databases. Similarly, web ad management site content and the social network site content will be hosted on separate servers. Company XYZ prefers to manage those two sites separately. The social network site will pull online ads from the database of the online ad management system. The users will experience a seamless presentation of ads within the social network pages without noticing the ads are fed from a different server.
Company XYZ awarded a contract to your company (Company ABC) to develop the web site, web service, and the database that will provide the capability of the online ad delivery and management service. You are the project manager of this project. Your task is to manage a team of three (one graphic designer, one database developer, and one software developer). As the project manager you are required to answer the following questions that provide insight about the project plan.
Explain how the online ads will be stored and served.
In: Computer Science