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
Suppose that a company offers quantity discounts. If up to 1000 units are purchased, the unit price is $ 10; if more than 1000 and up to 5000 units are purchased, the unit price is $ 9; and if more
1. Also the percentage increase for each occupational category.2. The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification
The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed and breakfast inn
The worksheet Base Data in the Excel file Credit Risk Data provides information about 425 bank customers who had applied for loans. The data include the purpose of the loan, checking and savings
A manager needs to identify some information from the Purchase Orders Excel file but has only the order number. Modify the Excel file to use the VLOOKUP function to find the item description and cost
A pharmaceutical manufacturer has projected net profits for a new drug that is being released to the market over the next five years:Use a spreadsheet to find the net present value of these cash
Described a scenario for new product sales that can be characterized by a formula called a Gompertz curve: S = aebect. Develop a spreadsheet for calculating sales using this formula for t = 0 to 160
Provided data from an experiment to identify the relationship between sales and pricing, coupon, and advertising strategies. Enter the data into a spreadsheet and implement the model in the example
The following exercises use the Purchase Orders database. Use MATCH and/ or INDEX functions to find the following:a. The row numbers corresponding to the first and last instance of item number 1369
Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database. First, she would like you to edit the worksheets Dealer Satisfaction and End-
Create a line chart for the closing prices for all years, and a stock chart for the high/ low/ close prices for August 2013 in the Excel file S& P 500.
Apply three different colors of data bars to lunch, dinner, and delivery sales in the Excel file Restaurant Sales to visualize the relative amounts of sales. Then sort the data (use a custom sort) by
For the Store and Regional Sales database, apply a four- traffic light icon set to visualize the distribution of the number of units sold for each store, where green corresponds to at least 30 units
For the Excel file Closing Stock Prices,a. Apply both column and line sparklines to visualize the trends in the prices for each of the four stocks in the file.b. Compute the daily change in the Dow
Convert the Store and Regional Sales database to an Excel table. For the Store and Regional Sales database, apply a four traffic light icon set to visualize the distribution of the number of units
Convert the Purchase Orders database to an Excel table. For the Store and Regional Sales database, apply a four- traffic light icon set to visualize the distribution of the number of units sold for
The Excel file Economic Poll provides some demographic and opinion data on whether the economy is moving in the right direction. Convert this data into an Excel table, and filter the respondents who
Open the Excel file Store and Regional Sales database.a. Sort the data by units sold, high to lowb. Sort the units sold using an icon set, where green corresponds to high sales levels, yellow to
Sort the data in the Excel file Automobile Quality from highest to lowest number of problems per 100 vehicles using the sort capability in Excel.
In the Purchase Orders database, conduct a Pareto analysis of the Cost per order data. What conclusions can you reach?
Use Excel’s filtering capability to (1) extract all orders for control panels, (2) all orders for quantities of less than 500 units, and (3) all orders for control panels with quantities of less
Create a pie chart showing the breakdown of occupations for each year in the Science and Engineering Jobs Excel file, and contrast these with simple column charts.
In the Sales Transactions database, use Excel’s filtering capability to extract all orders that used PayPal, all orders under $ 100, and all orders that were over $ 100 and used a credit card.
The Excel file Credit Risk Data provides information about bank customers who had applied for loans. 6 The data include the purpose of the loan, checking and savings account balances, number of
Use the COUNTIF function to construct a frequency distribution of the types of loans in the Excel file Credit Risk Data and develop a column chart to express the results visually.
Use the Histogram tool to construct a frequency distribution of lunch sales amounts in the Restaurant Sales database.
A community health status survey obtained the following demographic information from the respondents:Compute the relative frequency and cumulative relative frequency of the age groups.
Construct frequency distributions and histograms for the numerical data in the Excel file Cell Phone Survey. Also, compute the relative frequencies and cumulative relative frequencies.
Use the Histogram tool to develop a frequency distribution and histogram with six bins for the age of individuals in the Excel file Credit Risk Data. Compute the relative and cumulative relative
Use the Histogram tool to develop a frequency distribution and histogram for the number of months as a customer of the bank in the Excel file Credit Risk Data. Use your judgment for determining the
Construct frequency distributions and histograms using the Excel Histogram tool for the Gross Sales and Gross Profit data in the Excel file Sales Data. First let Excel automatically determine the
Find the 10th and 90th percentiles and the 1st and 3rd quartiles for the time difference between the scheduled and actual arrival times in the Atlanta Airline Data Excel file.
The Excel file Facebook Survey provides data gathered from a sample of college students. Create a scatter diagram showing the relationship between Hours online/week and Friends.
Find the 20th and 80th percentiles of home prices in the Excel file Home Market Value.
Find the 10th and 90th percentiles and 1st, 2nd, and 3rd quartiles for the combined amounts of checking and savings accounts in the Excel file Credit Risk Data.
Construct cross tabulations of Gender versus Carrier and Type versus Usage in the Excel file Cell Phone Survey. What might you conclude from this analysis?
Use PivotTables to construct a cross tabulation for the purpose of the loan and credit risk in the Excel file Credit Risk Data. Illustrate the results on a PivotChart.
Use PivotTables to construct a cross tabulation for marital status and housing type in the Excel file Credit Risk Data. Illustrate the results on a PivotChart.
Create a PivotTable to find the average amount of travel expenses for each sales representative in the Excel file Travel Expenses. Illustrate your results with a PivotChart.
Use PivotTables to find the number of loans by different purposes, marital status, and credit risk in the Excel file Credit Risk Data. Illustrate the results on a PivotChart.
Use PivotTables to find the number of sales transactions by product and region, total amount of revenue by region, and total revenue by region and product in the Sales Transactions database.
Create a PivotTable for the data in the Excel file Weddings to analyze the wedding cost by type of payor and value rating. What conclusions do you reach?
The Excel File Rin’s Gym provides sample data on member body characteristics and gym activity. Create PivotTables to find:a. A cross tabulation of gender and body type versus BMI classificationb.
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
Create useful dashboards for each of the following databases. Use appropriate charts and layouts ( for example, Explain why you chose the elements of the dashboards and how a manager might use them.
A marketing researcher surveyed 92 individuals, asking them if they liked a new product concept or not. The results are shown below:Convert the data into percentages. Then construct a chart of the
Create a bubble chart for the first five colleges in the Excel file Colleges and Universities for which the x- axis is the Top 10% HS, y- axis is Acceptance Rate, and bubbles represent the
Construct a column chart for the data in the Excel file State Unemployment Rates to allow comparison of the June rate with the historical highs and lows. Would any other charts be better to visually
The Excel file Internet Usage provides data about users of the Internet. Construct stacked bar charts that will allow you to compare any differences due to age or educational attainment and draw any
Construct an appropriate chart to show the proportion of funds in each investment category in the Excel file Retirement Portfolio.
In the Excel file Banking Data, apply the following data visualization tools:a. Use data bars to visualize the relative values of Median Home Value.b. Use color scales to visualize the relative
"Part 1: PLE originally produced lawn mowers, but a significant portion of sales volume over recent years has come from the growing small- tractor market. As we noted in the case in Chapter 1, PLE
Data obtained from a county auditor in the Excel file Home Market Value provide information about the age, square footage, and current market value of houses along one street in a particular
The data in the Excel file Church Contributions were reported on annual giving for a church. Estimate the mean and standard deviation of the annual contributions of all parishioners by implementing
A marketing study of 800 adults in the 18– 34 age group reported the following information:• Spent less than $ 100 but more than $ 0 on children’s clothing per year: 50 responses• Sspent $
The Excel file EEO Employment Report shows the number of people employed in different professions for various racial and ethnic groups. Find the proportion of men and women in each ethnic group for
In the Excel file Bicycle Inventory, find the proportion of bicycle models that sell for less than $ 200.
In the Sales Transactions database, find the proportion of customers who used PayPal and the proportion of customers who used credit cards. Also, find the proportion that purchased a book and the
In the Excel file Economic Poll, find the proportions of each categorical variable.
In the Excel file Facebook Survey, use a PivotTable to find the average and standard deviation of hours online/ week and number of friends for females and males in the sample.
In the Excel file Cell Phone Survey, use PivotTables to find the average for each of the numerical variables for different cell phone carriers and gender of respondents.
Using PivotTables, find the average and standard deviation of sales in the Sales Transactions database. Also, find the average sales by source (Web or e mail). Do you think this information could be
For the Excel file Travel Expenses, use a PivotTable to find the average and standard deviation of expenses for each sales rep.
In the Excel file Facebook Survey, find the average and median hours online/ week and number of friends in the sample using the appropriate Excel functions. Compute the midrange and compare all
Using PivotTables, compute the mean and standard deviation for each metric by year in the Excel file Freshman College Data. Are any differences apparent from year to year?
The Excel file Freshman College Data shows data for 4 years at a large urban university. Use PivotTables to examine differences in student high school performance and first year retention among
The Excel file Cell Phone Survey reports opinions of a sample of consumers regarding the signal strength, value for the dollar, and customer service for their cell phone carriers. Use PivotTables to
Call centers have high turnover rates because of the stressful environment. The national average is approximately 50%. The director of human resources for a large bank has compiled data about 70
In the Excel file Weddings, determine the correlation between the wedding costs and attendance.
For the data in the Excel file Rin’s Gym, find the co-variances and correlations among height, weight, and BMI calculation.
For the President’s Inn Guest Database file, find the average length of stay and number of guests. Is there any correlation between the size of the party and the length of stay?
The Excel file Beverage Sales lists a sample of weekday sales at a convenience store, along with the daily high temperature. Compute the covariance and correlation between temperature and sales.
For the Excel file Credit Risk Data, compute the correlation between age and months employed, age and combined checking and savings account balance, and the number of months as a customer and amount
In the Excel file Call Center Data, how strongly is length of service correlated with starting age?
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
The Excel file Auto Survey contains a sample of data about vehicles owned, whether they were purchased new or used, and other types of data. Use the Descriptive Statistics tool to summarize the
Compute the z- scores for the data in the Excel file Air-port Service Times. How many observations fall farther than three standard deviations from the mean? Would you consider these as outliers? Why
Use the Manufacturing Measurements data to compute sample averages, assuming that each row in the data file represents a sample from the manufacturing process. Plot the sample averages on a line
Find the mean and variance of a deck of 52 cards, where an ace is counted as 11 and a picture card as 10. Construct a frequency distribution and histogram of the card values. Shuffle the deck and
"A producer of computer aided design software for the aerospace industry receives numerous calls for technical support. Tracking software is used to monitor response and resolution times. In
A Midwest pharmaceutical company manufactures individual syringes with a self contained, single dose of an injectable drug. 7 In the manufacturing process, sterile liquid drug is poured into glass
Find 30 days of stock prices for three companies in different industries. The average stock prices should have a wide range of values. Using the data, compute and interpret the coefficient of
Compute descriptive statistics for liberal arts colleges and research universities in the Excel file Colleges and Universities. Compare the two types of colleges. What can you conclude?
Use the Descriptive Statistics tool to summarize the percent gross profit, gross sales, and gross profit in the Excel file Sales Data.
The worksheet Data in the Excel file Airport Service Times lists a large sample of the times in seconds to process customers at a ticket counter. The second worksheet shows a frequency distribution
Elizabeth Burke wants some detailed statistical information about much of the data in the PLE database. In particular, she wants to know the following:a. The mean satisfaction ratings and standard
The background for this case was introduced. This is a continuation of the case. For this part of the case, summarize the numerical data using descriptive statistics measures, find proportions for
"Lauren drinks a variety of soft drinks. Over the past month, she has had 15 diet colas, 4 cans of lemonade, and 6 cans of root beer in no particular order or pattern.a. Given this history, what is
A survey of 200 college graduates who have been working for at least 3 years found that 90 owned only mutual funds, 20 owned only stocks, and 70 owned both.a. What is the probability that an
Row 26 of the Excel file Census Education Data gives the number of employed persons having a specific educational level.a. Find the probability that an employed person has attained each of the
A survey of shopping habits found the percentage of respondents that use technology for shopping as shown in Figure 5.37. For example, 17.39% only use online coupons; 21.74% use online coupons and
A Canadian business school summarized the gender and residency of its incoming class as follows:a. Construct the joint probability table.b. Calculate the marginal probabilities.c. What is the
In an example in, we developed the following cross tabulation of sales transaction data:a. Find the marginal probabilities that a sale originated in each of the four regions and the marginal
Use the Civilian Labor Force data in the Excel file Census Education Data to find the following:a. P (unemployed and advanced degree)b. P (unemployed · advanced degree)c. P (not a high school grad
Using the data in the Excel file Consumer Transportation Survey, develop a contingency table for Gender and Vehicle Driven; then convert this table into probabilities.a. What is the probability that
A home pregnancy test is not always accurate. Suppose the probability is 0.015 that the test indicates that a woman is pregnant when she actually is not, and the probability is 0.025 that the test
"Consider the experiment of drawing two cards with-out replacement from a deck consisting of only the ace through 10 of a single suit (e. g., only hearts).a. Describe the outcomes of this experiment.
Roulette is played at a table similar to the one in Figure 5.36. A wheel with the numbers 1 through 36 ( evenly distributed with the colors red and black) and two green numbers 0 and 00 rotates in a
Consider the experiment of drawing two cards without replacement from a deck consisting of only the ace through 10 of a single suit (e. g., only hearts).a. Describe the outcomes of this experiment.
A consumer products company found that 48% of successful products also received favorable results from test market research, whereas 12% had unfavorable results but nevertheless were successful. They
Showing 2100 - 2200
of 5986
First
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Last