All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
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
Ask a Question
Search
Search
Sign In
Register
study help
business
business communication
Questions and Answers of
Business Communication
Call centers typically have high turnover. The director of human resources for a large bank has compiled data on about 70 former employees at one of the bank’s call centers in the Excel file Call
Using the data in the Excel file Airport Service Times, determine if the airline can claim that its average service time is less than 2.5 minutes.
The background for this case was introduced in Chapter 1. This is a continuation of the case in Chapter 6. For this part of the case, propose and test some meaningful hypotheses that will help Ms.
Each worksheet in the Excel file Line Fit Data contains a set of data that describes a functional relationship between the dependent variable y and the independent variable x. Construct a line chart
Using the Excel file Weddings, apply the Excel Regression tool using the wedding cost as the dependent variable and the couple’s income as the independent variable, only for those weddings paid for
Using the data in the Excel file Demographics, apply the Excel Regression tool using unemployment rate as the dependent variable and cost of living index as the independent variable.a. Interpret all
Using the data in the Excel file Student Grades, apply the Excel Regression tool using the midterm grade as the independent variable and the final exam grade as the dependent variable.a. Interpret
The Excel file National Football League provides various data on professional football for one season.a. Construct a scatter diagram for Points/ Game and Yards/ Game in the Excel file. Does there
A deep foundation engineering contractor has bid on a foundation system for a new building housing the world headquarters for a Fortune 500 company.A part of the project consists of installing 311
The Excel file Concert Sales provides data on sales dollars and the number of radio, TV, and newspaper ads promoting the concerts for a group of cities. Develop simple linear regression models for
Using the data in the Excel file Home Market Value, develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. Predict the value
The Excel file Cereal Data provides a variety of nutritional information about 67 cereals and their shelf location in a supermarket. Use regression analysis to find the best model that explains the
The Excel file Salary Data provides information on current salary, beginning salary, previous experience (in months) when hired, and total years of education for a sample of 100 employees in a
The Excel file Credit Approval Decisions provides information on credit history for a sample of banking customers. Use regression analysis to identify the best model for predicting the credit score
A consumer products company has collected some data relating monthly demand to the price of one of its products:What type of model would best represent these data? Use the Trend line tool to find the
Using the data in the Excel file Freshman College Data, identify the best regression model for predicting the first year retention rate. For the model you select, conduct further analysis to check
The Excel file Major League Baseball provides data on the 2010 season.a. Construct and examine the correlation matrix. Is multicollinearity a potential problem?b. Suggest an appropriate set of
The Excel file Golfing Statistics provides data for a portion of the 2010 professional season for the top 25 golfers.a. Find the best multiple regression model for predicting earnings/ event as a
Use the p- value criterion to find a good model for predicting the number of points scored per game by football teams using the data in the Excel file National Football League.
The State of Ohio Department of Education has a mandated ninth grade proficiency test that covers writing, reading, mathematics, citizenship (social studies), and science. The Excel file Ohio
A national homebuilder builds single family homes and condominium style townhouses. The Excel file House Sales provides information on the selling price, lot cost, type of home, and region of the
For the House Sales data described in Problem 25, develop a regression model for selling price as a function of lot cost and region, incorporating an interaction term. What would be the predicted
For the Excel file Auto Survey,a. Find the best regression model to predict miles/ gallon as a function of vehicle age and mileage.b. Using your result from part (a), add the categorical variable
Cost functions are often nonlinear with volume because production facilities are often able to produce larger quantities at lower rates than smaller quantities. 5 Using the following data, apply
The Helicopter Division of Aerospatiale is studying assembly costs at its Marseilles plant. 6 Past data indicates the following labor hours per helicopter:Using these data, apply simple linear
Using the data in the Excel file Demographics, determine if a linear relationship exists between unemployment rates and cost of living indexes by constructing a scatter chart. Visually, do there
For the Excel file Cereal Data, use XLMiner and best subsets with backward selection to find the best model.
Use XLMiner and best subsets with stepwise selection to find the best model points per game for the National Football League data Use the p- value criterion to find a good model for predicting the
Using the data in the Excel file Weddings construct scatter charts to determine whether any linear relationship appears to exist between (1) the wedding cost and attendance, (2) the wedding cost and
Using the data in the Excel file Student Grades, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the regression model? If a student scores 70 on the
Using the results of fitting the Home Market Value regression line Using the data in the Excel file Weddings construct scatter charts to determine whether any linear relationship appears to exist
Set up an Excel worksheet to apply formulas Using the data in the Excel file Student Grades, construct a scatter chart for midterm versus final exam grades and add a linear trendline. What is the
The managing director of a consulting group has the following monthly data on total overhead costs and professional labor hours to bill to clients: 4a. Develop a trendline to identify the
Using the Excel file Weddings, apply the Excel Regression tool using the wedding cost as the dependent variable and attendance as the independent variable.a. Interpret all key regression results,
Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting the temperature in Washington, D. C., using the data for years 1999 and 2000 in the Excel
Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years of data in the Excel file New Car Sales.
Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting housing starts beginning in June 2006 using the data in the Excel file Housing Starts.
Use the Holt Winters no trend model to find the best model to forecast the next year of electricity usage in the Excel file Gas & Electric.
Use the Holt Winters no trend model to find the best model to find forecasts for the next 12 months in the Excel file Housing Starts.
The Excel file CD Interest Rates provides annual average interest rates on 6 month certificate of deposits. Compare the Holt Winters additive and multiplicative models using XL Miner with the default
The Excel file Olympic Track and Field Data provides the gold medal winning distances for the high jump, discus, and long jump for the modern Olympic Games. Develop forecasting models for each of the
Choose an appropriate forecasting technique for the data in the Excel file Coal Consumption and find the best forecasting model. Explain how you would use the model to forecast and how far into the
Choose an appropriate forecasting technique for the data in the Excel file DJIA December Close and find the best forecasting model. Explain how you would use the model to forecast and how far into
Choose an appropriate forecasting technique for the data in the Excel file Federal Funds Rates and find the best forecasting model. Explain how you would use the model to forecast and how far into
Search the Conference Board’s Web site to find economic forecasts and reports about their business cycle indicators. Write a short report about your findings.
Choose an appropriate forecasting technique for the data in the Excel file Mortgage Rates and find the best forecasting model. Explain how you would use the model to forecast and how far into the
Choose an appropriate forecasting technique for the data in the Excel file Prime Rate and find the best forecasting model. Explain how you would use the model to forecast and how far into the future
Choose an appropriate forecasting technique for the data in the Excel file Treasury Yield Rates and find the best forecasting model. Explain how you would use the model to forecast and how far into
Data in the Excel File Microprocessor Data shows the demand for one type of chip used in industrial equipment from a small manufacturer.a. Construct a chart of the data. What appears to happen when a
The Excel file Energy Production & Consumption provides data on production, imports, exports, and consumption. Develop line charts for each variable and identify key characteristics of the time
The Excel file Unemployment Rates provides data on monthly rates for 4 years. Compare 3 and 12 month moving average forecasts using the MAD criterion. Explain why the 3 month model yields better
The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrials Index over a 1 month period.a. Develop spreadsheet models for forecasting each of the stock prices
"For the data in the Excel file Gasoline Prices do the following:a. Develop spreadsheet models for forecasting prices using simple moving average and simple exponential smoothing.b. Compare your
Consider the prices for the DJ Industrials in the Excel file Closing Stock Prices. The data appear to have a linear trend over the time period provided.a. Use simple linear regression to forecast the
Consider the data in the Excel file Consumer Price Index.a. Use simple linear regression to forecast the data. What would be the forecasts for the next 2 years?b. Use the double exponential smoothing
Consider the data in the Excel file Nuclear Power. Use simple linear regression to forecast the data. What would be the forecasts for the next 3 years?
Use XL Miner to generate a simple random sample of 10 records from the Excel file Banking Data.
Apply cluster analysis to the numerical data in the Excel file Credit Approval Decisions. Analyze the clusters and determine if cluster analysis would be a useful classification method for approving
Apply cluster analysis to the Excel file Sales Data, using the input variables Percent Gross Profit, Industry Code, and Competitive Rating. Create four clusters and draw conclusions about the
Cluster the records in the Excel file Ten Year Survey. Create up to five clusters and analyze the results to draw conclusions about the survey.
Use the k NN algorithm to classify the new data in the Excel file Credit Approval Decisions Coded using only credit score and years of credit history as input variables.
Use discriminant analysis to classify the new data in the Excel file Credit Approval Decisions Coded using only credit score and years of credit history as input variables.
Use logistic regression to classify the new data in the Excel file Credit Approval Decisions Coded using only credit score and years of credit history as input variables.
The Excel file Credit Risk Data provides a database of information about loan applications along with a classification of credit risk in column L. Convert the categorical data into numerical codes as
The Excel file Credit Risk Data provides a database of information about loan applications along with a classification of credit risk in column L. Convert the categorical data into numerical codes as
The Excel file Credit Risk Data provides a database of information about loan applications, along with a classification of credit risk in column L. Convert the categorical data into numerical codes
"For the PC Purchase Data, identify association rules with the following input parameters for the XL Miner association rules procedure:a. Support = 3; confidence = 90,b. Support = 7; confidence =
"Use the Excel file Banking Data.a. Construct a box plot for the Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance.b. What observations can you make about these
The Excel file Automobile Options provides data on options ordered together for a particular model of automobile. Develop a market basket analysis using the XL Miner association rules procedure with
The Excel file Myatt Steak House provides 5 years of data on key business results for a restaurant. Identify the leading and lagging measures, find the correlation matrix, and propose a cause and
Construct a parallel coordinate’s chart for Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance in the Excel file Banking Data. What conclusions can you reach?
Construct a scatter plot matrix for Median Income, Median Home Value, Median Household Wealth, and Average Bank Balance in the Excel file Banking Data. What conclusions can you reach?
Construct a variable plot for all the variables in the Excel file Banking Data.
Compute the Euclidean distance between the following sets of points:a. (2,5) and (8,4)b. (2, - 1, 32)and (8, 15, - 5)
For the Excel file Colleges and Universities, normalize each column of the numerical data (i. e., compute a z-score for each of the values) and then compute the Euclidean distances between the
"For the four clusters identified Compute the Euclidean distance between the following sets of points:a. (2, 5) and (8, 4)b. (2, - 1, 32) and (8, 15, - 5),Find the average and standard deviations of
For the Colleges and Universities data, use XLMiner to find four clusters using each of the other clustering methods (see Figure 10.13); compare the results Compute the Euclidean distance between the
The worksheet Purchasing Survey in the Performance Lawn Care database provides data related to predicting the level of business (Usage Level) obtained from a third party survey of purchasing managers
Develop a spreadsheet model for gasoline Suggest some metrics that a manager of a fast food restaurant, such as McDonald’s or Chipotle, might want to collect. Describe how the manager might use the
A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty five percent of those interested are found not
The director of a nonprofit ballet company in a medium sized U. S. city is planning its next fundraising campaign. In recent years, the program has found the following percentages of donors and gift
A gasoline mini mart orders 25 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The gasoline mini mart purchases the magazines for $ 1.50 and sells them for
Koehler Vision Associates (KVA) specializes in laser assisted corrective eye surgery. Prospective patients make appointments for prescreening exams to determine their candidacy for the surgery: if
Tanner Park is a small amusement park that provides a variety of rides and outdoor activities for children and teens. In a typical summer season, the number of adult and children’s tickets sold are
With the growth of digital photography, a young entrepreneur is considering establishing a new business, Cruz Wedding Photography. He believes that the average number of wedding bookings per year is
The Executive Committee of Reder Electric Vehicles is debating whether to replace its original model, the REVTouring, with a new model, the REV Sport, which would appeal to a younger audience.
The Schoch Museum is embarking on a 5 year fundraising campaign. As a nonprofit institution, the museum finds it challenging to acquire new donors as many donors do not contribute every year. Suppose
Apply the Data Validation tool to the President’s Inn Guest Database file with an error alert message box to ensure that dates are in the month of December and correctly entered, and that the
Insert a spin button and scroll bar in the Outsourcing Decision Model to allow the user to easily change the production volume in cell B12 from 500 to 3000. Which one is easier to use? Discuss the
Develop a spreadsheet model for Classify each of the data elements in the Sales Transactions database (Figure 1.1) as categorical, ordinal, interval, or ratio data and explain why. Apply the
Insert a spin button in the Moore Pharmaceuticals model to change the discount rate in cell B8 from 1% to 10% in increments of one tenth.
For the Pro Forma Income Statement model in the Excel file Net Income Models (Figure 11.7), add a scroll bar form control to allow the user to easily change the level of sales from 3,000,000 to
Create a new worksheet in the Retirement Portfolio workbook. In this worksheet, add a list box form control to allow the user to select one of the mutual funds on the original worksheet, and display
Using the matrix of intercity distances in the American Baseball League file, add list box form controls so that the user can choose two cities (using two list boxes) and find the distance between
A manufacturer of mp3 players is preparing to set the price on a new model. Demand is thought to depend on the price and is represented by the modelD = 2,500 - 3PThe accounting department estimates
The demand for airline travel is quite sensitive to price. Typically, there is an inverse relationship between demand and price; when price decreases, demand increases, and vice versa. One major
Use the Markdown Pricing Model spreadsheet model and a two way data table to find the total revenue if days at full retail vary from 20 to 40 in increments of 5 and the intermediate markdown varies
The weekly price at an extended stay hotel ( renting by the week for business travelers) is $ 950. Operating costs average $ 20,000 per week, regardless of the number of rooms rented. Construct a
For the Koehler Vision Associates model you developed Koehler Vision Associates ( KVA) specializes in laser assisted corrective eye surgery. Prospective patients make appointments for prescreening
A stockbroker calls on potential clients from referrals. For each call, there is a 10% chance that the client will decide to invest with the firm. Fifty five percent of those interested are found not
Showing 2300 - 2400
of 5986
First
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Last