New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
mathematics
statistics for managers using microsoft excel
Statistics For Managers Using Microsoft Excel 9th Edition David M. Levine, David F. Stephan, Kathryn A. Szabat - Solutions
In 44 of the 68 years from 1950 through 2018 (in 2011 there was virtually no change), the S&P 500 finished higher after the first five days of trading. In 36 out of 44 years, the S&P 500 finished higher for the year. Is a good first week a good omen for the upcoming year? The following
G2 Crowd provides commentary and insight about employee engagement trends and challenges within organizations in its G2 Crowd Employee Engagement Report. The report represents the results of an online survey conducted in 2019 with employees located across the United States. G2 Crowd was interested
In the last quarter of 2018, 47% of U.S. smartphone owners owned an iPhone.Using the binomial distribution, what is the probability that of the next six Americans who own a smartphone surveyed,a. Four will own an iPhone?b. All six will own an iPhone?c. At least four will own an iPhone?d. What are
The Internet has become a crucial marketing channel for business. According to a recent study, 91% of retail brands use two or more social media channels for business. If a sample of 10 businesses is selected, what is the probability that:a. 8 use two or more social media channels for business?b.
Millennial s spent a mean of $163 per month o n dining in 2018.Assume that the amount spent on dining per nth is normally distributed and that the standard deviation is $25.a. What is the probability that a randomly selected millennial s pent more than $ 100 per month?b. What is the probability
In 2017, the per capita consumption of soft drinks in the United States was reported to be 37.5 gallons.Assume that the per capita consumption of soft drinks in the United States is approximately normally distributed with an of 37.5 gallons and a standard deviation of 8 gallons.a. What is the
Thirty companies comprise the DJIA. How big are these companies? One common method for measuring the size of a company is to use its market capitalization, which is computed by multiplying the number of stock shares by the price of a share of stock.On April 24, 2019, the market capitalization of
The file CD Rates contains the yields for a one-year certificate of deposit (CD) and a five-year CD for 46 banks listed for West Palm Beach, Florida on April 5, 2019.For each type of investment, decide whether the data appear to be approximately normally distributed bya. Comparing data
Given a normal distribution withμ, = 50 and a = 5, if you select a sample of n = 100, what is the probability that X isa. Less than 47?b. Between 47 and 49.5?c. Above 51.1 ?d. There is a 35% chance that X is above what value?
The U.S. Census Bureau announced that the median sales price of new houses sold in January 2018 was $323,000, and the mean sales price was $382,700.Assume that the standard deviation of the prices is $90,000.a. If you select samples of n = 4, describe the shape of the sampling distribution of X.b.
According to the National Survey of Student Engagement, the average student spends about 15 hours each week preparing for classes; preparation for classes includes homework, reading and any other assignments.Assume the standard deviation of time spent preparing for classes is 4 hours. If you select
According to a survey in December 2018 of Women on Boards, women hold 21.7% of director seats on U.S. corporate boards. This study also reports that 39.2% of U.S. companies have three or more female board directors.If you select a random sample of 200 U.S. companies,a. What is the probability that
Referring to Problem 7.18, the same survey reported that 20.9% of German companies have women directors and 80% have three or more women on the board.If you select a random sample of 200 German companies,a. What is the probability that the sample will have between 70% and 78% companies that have
The stock market in Qatar reported strong return s in the first 11 months of 2018. The population of s tocks earned a mean return of 21.19 % in 2018.Assume that the re turns for s tock s on the Q a ta r stock market were distributed as a norm al variable, with a mean of 21.19 and a standard
Forth e year 2018, the stock market in Germany had a mean return of - 12.53% in 2018. Assume that the return s for stocks on the Germ an stock market were distributed normally, with a mean of - 12.53 % and a standard deviation of 10. If you select an individuals tock from this population, what is
The file contains Credit Scores the average credit scores of people from 2,750 American cities.a. Select five different samples of n = 2, n = 5, n = 15, and n = 30.b. Compute the sample mean of each sample. Develop a frequency distribution of the sample means for the results of the entire
The Super Bowl, watched by close to 200 million Americans, is also a big event for advertisers. The file Super Bowl Ad Ratings contains the rating of ads that ran between the opening kickoff and the final whistle.For ads that ran before halftime and ads that ran at halftime or after separately:a.
If n = 200 and X = 50, construct a 95% confidence interval estimate for the population proportion.
An Ipsos poll asked 1,004 adults, "If purchasing a used car made certain upgrades or features more affordable, what would be your preferred luxury upgrade?" The results indicated that 9% of males and 14% of females answered window tinting.The poll description did not state the sample sizes of males
Let n1 = 100, X1 = 50, n2 = 100, and X2 = 30.a. At the 0.05 level of significance, is there evidence of a significant difference between the two population proportions?b. Construct a 95% confidence interval estimate for the difference between the two population proportions.
Let n1 = 100, X1 = 45, n2 = 50, and X2 = 25.a. At the 0.01 level of significance, is there evidence of a significant difference between the two population proportions?b. Construct a 99% confidence interval estimate for the difference between the two population proportions.
The more costly and time-consuming it is to export and import, the more difficult it is for local companies to be competitive and to reach international markets. As part of an initial investigation exploring foreign market entry, 10 countries were selected from each of four global regions. The cost
Using Table E.6, determine the lower- and upper-tail critical values for the Wilcoxon rank sum test statistic, T1 , in each of the following two-tail tests:d. Given the results in (a) through (c), what do you conclude regarding the width of the region of nonrejection as the selected level of
Using Table E.6, determine the lower-tail critical value for the Wilcoxon rank sum test statistic, T1 , in each of the following one-tail tests: a. a = 0.05, n = 6, n = 8 b. a = 0.025, n = 6, n %3D c. a = 0.01, n d. a = 0.005, n = 8 = 6, n2 = 8 = 6, n, = 8
In Problem 12.29, what are the lower- and upper-tail critical values for the test statistic T1 from Table E.6 if you use a 0.05 level of significance and the alternative hypothesis is H1: M1 ≠ M2?Problem 12.29The following information is available for two samples selected from independent
Brand valuations are critical to CEOs, financial and marketing executives, security analysts, institutional investors, and others who depend on well-researched, reliable information for assessments and comparisons in decision making. Kantar Millward Brown annually publish the BrandZ Top Global
In Problem 13.4, the percentage of .mm alcohol was used to predict wine quality (stored in Vinho Verde) For those data, SSR = 21.8677 and SST = 64.0000.a. Determine the coefficient of determination, r2, and interpret its meaning.b. Determine the standard error of the estimate.c. How useful do you
What is the relationship between the price of crude oil and the price you pay at the pump for gasoline? The fie Oil & Gasoline contains the price($) for a barrel of crude oil (Cushing, Oklahoma, spot price) and a gallon of gasoline (U.S. average conventional s pot price) for 236 weeks ending
In Problem 14.6 on page 483, you used full-time voluntary turnover(%), and total worldwide revenue ($billions) to predict number of full-time jobs added (stored in Best Companies).a. Perform a residual analysis on your results.b. If appropriate, perform the Durbin-Watson test, using a =
Using the data for Problem 16.17 concerning the number of automobiles assembled in the United States from 1999 to 2018 (stored in Auto Production),a. Fit a third-order autoregressive model to the number of automobiles assembled in the United States and test for the significance of the third-order
Using the average baseball salary from 2000 through 2019 data for Problem 16.18 (stored in MLB Salaries)a. Fit a third-order autoregressive model to the average baseball salary and test for the significance of the third-order autoregressive parameter. (Use a = 0.05.)b. If necessary, fit a
In forecasting a monthly time series over a five-year period from January 2014 to December 2018, the exponential trend forecasting equation for January isTake the antilog of the appropriate coefficient from this equation and interpret thea. Y intercept, b0.b. Monthly compound growth rate.c. January
Using the yearly amount of solar power generated by utilities (in millions of kWh) in the United States from 2002 through 2018 data for Problem 16.16 on page 572 (stored in Solar Power),a. Fit a third-order autoregressive model to the amount of solar power installed and test for the significance of
Using the data for the number of automobiles assembled in the United States for Problem 16.17 and Problem 16.29 (stored in Auto Production),a. Perform a residual analysis for each model.b. Compute the standard error of the estimate (S rx) for each model.c. Compute the MAD for each model.d. On the
Refer to the exponential model given in Problem 16.42.a. What is the fitted value of the series in the fourth quarter of 2018?b. What is the fitted value of the series in the first quarter of 2018?c. What is the forecast in the fourth quarter of 2019?d. What is the forecast in t he first quarter of
The data in Target are quarterly revenues (in $millions) for Target from 2000-QI through 2019-QI.a. Do you think that the revenues for Target are subject to seasonal variation? Explain.b. Plot the data. Does this chart sup port your answer in (a)?c. Develop an exponential trend forecasting equation
Are gasoline prices higher during the height of the summer vacation season than at other times? The file Gas Prices contains the mean monthly prices (in $/gall on) for unleaded gasoline in the United States from January 2006 to July 2019.a. Construct a time-series plot.b. Develop an exponential
The file Crude Oil contains the volume (in barrels) of Canadian crude oil exports by rail from January 2012 to May 2019.a. Plot the time-series data.b. Develop an exponential trend forecasting equation with monthly components.c. What is the fitted value in May 2019?d. What are the forecasts for the
The file Silver-Q contains the price in London for an ounce of silver (i n US$) at the end of each quarter from 2004 through 2018.a. Plot t he data.b. Develop an exponential trend forecasting equation with quarterly components.c. Interpret the quarterly compound growth rate.d. Interpret the first
What are the advantages and disadvantages of using expected monetary value (EMV) as compared to the return-to-risk ratio (RTRR)?
Many factors affect attendance at Major League Baseball (MLB) games. Among the factors are those relating to the capacity of the stadium, how the team performed during the season, and characteristics about the team itself. For each MLB team in a recent year, the file MLB Attendance Study includes
The file Travel and Tourism contains 2018 travel and tourism industry data for a sample of 28 European countries. Variables included are travel and tourism jobs (in thousands), nights spent by European residents at tourism establishments (in millions), euros spent by European residents at tourism
As a consultant to an investment company trading in various currencies, you have been assigned the task of studying long-term trends in the exchange rates of the Canadian dollar, the Japanese yen, and the English pound. Data from 1980 to 2018 are stored in Currency, where the Canadian dollar, the
Teachers' Retirement System of the City of New York offers several types of investments for its members. Among the choices are investments with fixed and variable rates of return. There are several categories of variable-return investments. The Diversified Equity Fund consists of investments that
The file McDonalds contains the gross revenues (in billions of current dollars) of McDonald's Corporation from 1975 through 2018:a. Plot the data.b. Compute the linear trend forecasting equation.c. Compute the quadratic trend forecasting equation.d. Compute the exponential trend forecasting
The monthly commercial and residential prices for natural gas (dollars per thousand cubic feet) in the United States from January 2008 through May 2019 are stored in Natural Gas.For the commercial price and the residential price,a. Do you think the price for natural gas has a seasonal component?b.
The U.S. Department of Labor gathers and publishes statistics concerning the tabor market. The file Workforce contains the size of the U.S. civilian noninstitutional population of people 16 years and over (in thousands) and the U.S. civilian noninstitutional workforce of people 16 years and over
The file Gold contains the price in London for an ounce of gold (in US$) at the end of each quarter from 2004 through 2018.a. Plot the data.b. Develop an exponential trend forecasting equation with quarterly components.c. Interpret the quarterly compound growth rate.d. Interpret the first quarter
If n = 400 and X = 25, construct a 99% confidence interval estimate for the population proportion.
Personal data are the new currency of the digital economy. How do consumers feel about sharing personal data with their communication service providers (CSPs)? A recent IBM report highlights that 40% of 18- to 25-year-old consumers are comfortable sharing personal data with their CSPs.a. To conduct
CarMD reports that the mean repair cost of a Toyota in 2018 for a "check engine" light was $482.Suppose a sample of 100 "check engine" light repairs completed in the last month was selected. The sample mean repair cost was $271 with the sample standard deviation of $ 100.a. Is there evidence that
A study found that 51 children who watched a commercial for Walker Crisps ( potato chips) featuring a long-standing sports celebrity endorser ate a mean of 36 grams of Walker Crisps as compared to a me an of 25 grams of Walker Crisps for 41 children who watched a commercial for an alternative food
Do upload and download speeds vary between cities and Internet service providers? The file Internet Provider Speeds contains the upload and download speeds in Mbps in 40 different cities for four Internet service providers, AT&T, T-Mobile, Sprint, and Verizon, as measured in November 2017. In
Do upload and download speeds vary between cities and Internet service providers? The file Internet Provider Speeds contains the upload and download speeds in Mbps in 40 different cities for four Internet service providers, AT&T, T-Mobile, Sprint, and Verizon, as measured in November 2017. In
If you have samples of n1 = 12 and n2 = 15, in performing the pooled-variance t test, how many degrees of freedom do you have?
What is meant by a p-value?
What is the difference between a one-tail test and a two-tail test?
The worldwide market share for the Chrome web browser was 69.52 % in March 2019.Suppose that you decide to select a sample of 100 students at your university and you find that 60 use the Chrome web browser.a. Use the six-step p-value approach to determine whether the re is evidence that the market
A growing share of Americans use smartphones as their primary means of online access at home. A survey of U.S. adults found that 58% of the 18- to 29-year-olds, 47% of the 30- to 49 year-olds, 27% of the 50- to 64-year-olds, and 15% of those age 65 or older mostly use a smartphone to go
Even though there has been an abundance of digital and analytics transformations occurring across the business landscape in recent years, few companies report achieving successful results. What has been the major objectives of company digital and analytics transformations? A McKinsey Global survey
The MSCI 2018 Survey of Women on Boards showed that there continues to be a slow increase in the overall percentage of women on boards globally. The study reported that 72 of 72 (100%) French companies sampled, 49 of 62 (79%) German companies sampled, 14 of 24 (58.3%) Irish companies sampled, 15 of
What is the upper-tail critical value from the chi-square distribution if you use the Kruskal-Wallis rank test for comparing the medians in six populations at the 0.01 level of significance?
Under what conditions should you use the x2 test to determine whether there is a difference between the proportions of two independent populations?
Under what conditions should you use the x2 test to determine whether there is a difference among the proportions of more than two independent populations?
Starbucks Coffee Co. uses a data-based approach to improve the quality and customer satisfaction of its products. When survey data indicated that Starbucks needed to improve its package-sealing process, an experiment was conducted to determine the factors in the bag-sealing equipment that might be
You are using exponential smoothing on an annual time series concerning total revenues (in $millions). You decide to use a smoothing coefficient of W = 0.20, and the exponentially smoothed value for 2019 is £2019 = (0.20)(12.1) + (0.80)(9.4).a. What is the smoothed value of this series in 2019?b.
A sports statistician seeks to evaluate NBA team statistics for a recent year. The statistician collects data for wins and points scored, field goal percentage, opponent field goal percentage,three point field goal percentage, free throw percentage, rebounds per game, assists per game, and
The data below, stored in Computer Usage represent the hours per day spent by American desktop and laptop users from 2008 to 2017.a. Plot the time series.b. Fit a three-year moving average to the data and plot the results.c. Using a smoothing coefficient of W = 0.50, exponentially smooth the series
How have stocks performed in the past? The following table presents the data stored in Stock Performance, which show the performance of a broad measure of stock performance (by percentage) for each decade from the 1830s through the 2010s:a. Plot the time series.b. Fit a three-period moving average
Gross domestic product (GDP) is a major indicator of a nation's overall economic activity. It consists of personal consumption expenditures, gross domestic investment, net exports of goods and services, and government consumption expenditures. The file GDP contains the GDP (in billions of current
The data in Federal Receipts represent federal receipts from 1978 through 2018 in billions of current dollars, from individual and corporate income tax, social insurance, excise tax, estate and gift tax, customs duties, and federal reserve deposits.a. Plot the series of data.b. Compute a
The file House Sales contains the number of new, single-family houses sold in the United States from 1992 through 2018.a. Plot the data.b. Compute a linear trend forecasting equation and plot the trend line.c. Compute a quadratic trend forecasting equation and plot the results.d. Compute an
The average salary of Major League Baseball players on opening day from 2000 to 2019 is stored in MLB Salaries and in the following table.a. Plot the data.b. Compute a linear trend forecasting equation and plot the trend line.c. Compute a quadratic trend forecasting equation and plot the results.d.
The data shown in the following table and stored in Solar Power represent the yearly a mount of solar power generated by utilities (in millions of kWh) in the United States from 2002 through 2018:a. Plot the data.b. Compute a linear trend forecasting equation and plot the trend line.c. Compute a
The file Auto Production contains the number of automobiles assembled in the United States (in thousands) from 1999 to 2018.a. Plot the data.b. Compute a linear trend forecasting equation and plot the trend line.c. Compute a quadratic trend forecasting equation and plot the results.d. Compute an
What are the major categories of business analytics?
Explain the difference between explanatory and prediction models.
What prevented the widespread adoption of business analytics in the past?
What is artificial intelligence, and what is its relationship to machine learning?
What is text analytics relationship to clustering and association methods?
How does clustering differ from association analysis?
How do dashboards enable business analytics users to explore data?
How are decision criteria used in decision rules?
What are the two main approaches in prescriptive analytics?
Churn occurs when customers stop doing business with a company or stop subscribing to a service. The file Bank Churn Study contains data from a churn study conducted by an international bank.For each bank customer in the sample, the study includes ID number, credit score, domicile, gender, age,
Wally's Discount Stores sell basic essentials for food, home, health, apparel, and home. Wally's produces and sells private-label goods under its ShowGo label in addition to select nationally advertised brands. The file Wally's contains a sample of 410 Wally's shoppers who purchased ShowGo products
What is meant by "data dimensionality?"
What are the advantages and disadvantages of a payoff table as compared to a decision tree?
What are the advantages and disadvantages of using expected monetary value (EMV) as compared to the return-to-risk ratio (RTRR)?
What are the advantages and disadvantages of a payoff table as compared to a decision tree?
What is the difference between an event and an alternative course of action?
Recently, Ashland MultiComm Services has been criticized for its inadequate customer service in responding to questions and problems about its telephone, cable television, and Internet services. Senior management has established a task force charged with the business objective of improving customer
What is the difference between a drill-down and a slicer?
Showing 100 - 200
of 193
1
2
Step by Step Answers
Get 50% OFF
Claim Now
