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
AI Study Help
New
Search
Search
Sign In
Register
study help
mathematics
statistics
Questions and Answers of
Statistics
The file P18_25.xlsx contains the following data on movie stars: the name of each star, the star's gender, domestic gross (average domestic gross of the star's last few movies), foreign gross
The file P18_26.xlsx contains data on a bank's employees. Check for bad or suspicious values and change them appropriately?
The file P18_27.xlsx contains data on 500 randomly selected households. Check for bad or suspicious values and change them appropriately?
The file P18_29.txt contains yearly data on the projected population growth rate for several countries. Import this data into Excel, change the labels in the first row so that only the country name
The file P18_03.xlsx is the result of importing a text (.txt) file into Excel. The first column should be Year, and this should be followed by four columns for each state: the number and the
Sometimes the data you find on the Web is embedded in a Word document. For example, the file P18_30.docx contains an air traffic report from June 2009, including a number of tables. Table 3 of the
The Organization for Economic Co-operation and Development (OECD) website stats.oecd.org/index.aspx has a wealth of economic data. For example, under Monthly Economic Indicators, find International
Create an appropriate query that returns the course code, course name, course description, category, and department of all courses in the database, and then return the data to Excel as a table?
Create an appropriate query that returns a list of all students in all sections. Specifically, it should return the student's first and last name, the course name, the section number, and the
Create an appropriate query and return the results to Excel as a pivot table. The pivot table should allow you to choose a building name (from the Filters area or a slicer) and see the number of
Create an appropriate query and return the results to Excel as a pivot table. The pivot table should allow you to choose a department name (from the Filters area or a slicer) and see the number of
Create an appropriate query that lists the company names of all of North-wind's customers and their countries. Return the results to Excel as a table. Then build a pivot table from this table that
Create an appropriate query that lists the first and last names of each employee and the person, if any, that employee reports to. (This is a case where the Employees table includes a primary key,
Create an appropriate query that returns the following information for all products that have not been discontinued: product name, product category name, unit price, units in stock, and units on
Create an appropriate query to find the names of all artists and the instruments they play. Return the data into an Excel table. Then create a pivot table from this table and use it to find a list of
The file P18_04.xlsx contains monthly data since 1931 on the number of cooling degree-days (CDD, an index of the amount of energy to cool a home or business) in each of the United States and several
Create an appropriate query to find the titles of all works in the collection and the corresponding composer names. Return the data as a pivot table. Then use the pivot table to find all of the works
The file P18_41.txt contains yearly data on the number and percentage of people without health insurance by state. Try importing this data into Excel. What goes wrong with the first row, which should
(Based on the School Schedule database) Create an appropriate query that enables you to determine, for each student, how many classes the student has each day of the week. Note that the
(Based on the Northwind database) Create an appropriate query and return it as a pivot table. This pivot table should allow you to see the number of orders shipped by each shipper during each
(Based on the North-wind database) Create an appropriate query that allows you to see the total revenue broken down by any of product name, product category, month-year of order date, or customer.
(Based on the Classical CDs database) Create an appropriate query to find all of the works conducted by Bernstein, Leonard. (Use a filter for the conductor.) Return the data as a table to Excel. The
(Based on the Classical CDs database) Create a query to find the following fields: Artist from Artists, Composer from Composers, Conductor from Conductors, Orchestra from Orchestras, and Title from
The file Foodmart.mdb contains many transactions at a supermarket chain. Open this file in Access, click on Database Tools and select Relationships to see the relationships diagram. This type of
In analogy with the previous problem, the file P18_05.xlsx contains monthly data since 1931 on the number of heating degree days (HDD, an index of the amount of energy to heat a home or business) in
The file P18_06.xlsx contains monthly data from 1920 to 2004 on average temperatures in the 48 contiguous states and several regions of the U.S. (The codes for locations are listed on the Locations
The file P18_07.txt lists monthly values of the consumer price index (CPI). Import this data into Excel, excluding the rows before the actual data. (Many text files have information in the first few
The file P18_08.txt lists daily values of an air quality index for Los Angeles. The first value in each row is a date such as 20070322. This means March 22, 2007. Import this data into Excel and save
The files P18_09 AL.txt and P18_09 NL.txt contain lists of all American League and National League baseball batters who had at least 250 at-bats during the 1990 season. The heading at the top of each
Text data can sometimes be quite intimidating. As an example, the file P18_14.txt has data on all organizations convicted in federal courts in 2007. If you open it in Notepad, it won't make a bit of
Consider a data set with monthly data on some variable. The data are arranged so that there is a column for each month, Jan to Dec, and a row for each year. Is it possible to create a single time
Why is data stored so often in "plain vanilla" text files? After all, a text editor like Notepad has virtually no tools for analysis.
Suppose you have data such as in the Shirt Orders database. How could this data be stored in an Excel file? Would anything be lost? In general, what is the advantage of storing such data in a
Continuing the previous question, if there is an advantage of storing this type of data in Access, why should you bother importing it into Excel?
What is the advantage of using SQL for queries? (Although you might not know SQL at this point, virtually all database analysts know it and use it often.)
If you find data of interest on a website, discuss the options for importing it into Excel for analysis. Why isn't there a single method that always works? Do you think there ever will be such a
Suppose that you are given a data set in Excel, but because of the source, you suspect that it has some bad data. What tools would you typically use, and how would you use them, to find the bad data?
Suppose that a producer of single-room air conditioners wishes to test four prototype air conditioning units. The dependent variable is the number of days an air conditioner will function properly
Consider again the one-way ANOVA hypothesis test described in Problem 6. How could blocking be employed to control for a factor that is not of primary interest yet could introduce an unwanted source
Consider again the one-way ANOVA hypothesis test described in Problem 7. How could blocking be employed to control for a factor that is not of primary interest yet could introduce an unwanted source
Consider again the one-way ANOVA hypothesis test described in Problem 29. Suppose now that the professional golf association wants to compare the mean distances traveled by four brands of golf balls
ANOVA is always a test of the equality of means. So why is the method called analysis of variance?
Part of the title of this chapter is "experimental design." Why is the design of an experiment so important? What is the main disadvantage of an experiment that is not properly designed?
In ANOVA terminology, there are "factors" and "treatment levels." Give at least two examples of possible factors and treatment levels to illustrate that you understand what these terms mean.
Explain what the key ratio, the F ratio, in a one-way ANOVA table is all about and why it is the basis for a test of equal means.
Explain why there are several choices (in StatTools and other packages) for the type of confidence intervals in one-way ANOVA. Specifically, whatp roblem do these variations attempt to solve?
Explain exactly how regression can be used as an alternative to the "standard" one-way ANOVA methodology. Which p-values from the two methods are guaranteed to be the same?
In academic papers that are based on data analysis, you often see a correlation matrix from the observed data with asterisks indicating the "significant" correlations (those that are significantly
What is the difference between a full factorial design and an incomplete factorial design? If the former is "better," why would you ever use the latter?
A study is performed on a sample of residential homes to discover whether the size of the monthly heating bill depends on the type of heat or the type of home. In particular, three types of heat are
Chapters 8 and 9 discussed paired comparisons as one possibility when analyzing the difference between two means. What does this have to do with blocking, as discussed in Section 19-6b?
The file P20_01.xlsx contains data on the amount of soda (in ounces) placed in aluminum cans by a particular filling process. Ideally, the filling process should place 12 ounces of soda in each can.
The file P20_10.xlsx contains the breaking strengths (measured in pounds) of randomly selected pieces of a certain welded material. In particular, these data consist of 25 subsamples of 5 observed
The file P20_11.xlsx contains data on the amount of liquid detergent (in ounces) placed in plastic containers by a particular filling process. Ideally, the filling process should place 100 ounces of
Management of a local bank is interested in assessing the process used in opening new checking accounts for bank customers. In particular, management would like to examine the time required to
The manager of a supermarket would like to evaluate the effectiveness of a large freezer unit currently used to store excess supplies of various frozen food items in the supermarket's inventory.
Consider a situation where a given process goes out of control but the relevant control charts do not indicate so. Assume that the process variation remains constant but the mean shifts from μ to μ
Consider a situation where a given process goes out of control but the relevant control charts do not indicate so. Assume that the process variation remains constant but the mean shifts from μ to μ
Suppose that a manufacturer of electronic computer chips classifies each chip as either defective or non defective. Each hour 100 electronic chips are randomly selected from a very large batch of
Construct and interpret a p chart for the data provided in the file P20_17.xlsx. These data consist of the number of defective units found in each of 25 samples with a common size of 200 units. Is
Continuing the previous problem, suppose that the given production process has been modified in an effort to reduce the variation in the proportion of defective items. An additional 25 samples that
Construct and interpret a p chart for the data provided in the file P20_19.xlsx. These data consist of the number of defective units found in each of 25 samples with a common size of 100 units. Is
The data in the file P20_02.xlsx consist of 25 subsamples of 4 observations each on the diameters (measured in centimeters) of ball bearings produced by a manufacturing process. The target diameter
Suppose that a manufacturer of a particular automotive part classifies each unit produced as either defective or non defective. Each hour 200 parts are randomly selected from a very large batch of
A new online bookstore ships thousands of books to its customers each week. The director of this firm's shipping department is concerned about a seemingly large number of complaints from customers
Continuing the previous problem, the firm's shipping director has implemented a new quality control program within her department. She is interested in determining whether this program is reducing
Construct and interpret a p chart for the data provided in the file P20_23.xlsx. These data consist of the proportion of defective heating control units found in each of 30 samples with a common size
Construct and interpret a p chart for the data provided in the file P20_24.xlsx. These data consist of the proportion of defective light bulbs found in each of 30 samples with a common size of 100
Continuing the previous problem, the managers of this manufacturing process have implemented more stringent quality control procedures to reduce the variability of the light bulbs' defective rate.
Management of a new credit card company has recorded the number of nonconforming customer bills found in random samples of 150 bills obtained during the first 30 weeks of the firm's operation. These
A mail-order clothing retailer is interested in improving the accuracy of its customer service agents who enter customer orders into the firm's computerized record system. To monitor the accuracy of
Construct and interpret a p chart for the data provided in the file P20_28.xlsx. These data consist of the proportion of defective radar detectors found in each of 30 samples with a common size of
The data in the file P20_03.xlsx consist of 25 subsamples of 6 observations each on the fill weights of cans of paint. The ideal fill weight of these paint cans is 20 pounds.a. Generate and interpret
Provided that p̅ = 0.01, determine a sample size large enough to avoid the construction of a p chart with a negative lower control limit. How does this required sample size change when p increases
To establish the subsample size n for a p chart, a probability of 0.95 is specified for finding at least one nonconforming item in any subsample of n items. If the process has an average
For a fixed subsample size n, what values of p lead to a positive lower control limit on a p̅ chart?
The file P20_01.xlsx contains data on the amount of soda (in ounces) placed in aluminum cans by a particular filling process. The filling process should place between LSL = 11.95 ounces and USL =
The data in the file P20_07.xlsx consist of 25 subsamples of 4 observations each on the lengths of particular bolts manufactured for use in large aircraft. The target length of these bolts is 37
Management of a local bank is interested in assessing the process used in opening new checking accounts for bank customers. In particular, management would like to examine the time required to
Suppose that a product is composed of 25 identical and probabilistically independent parts. Assume that this product is manufactured through the use of a k-sigma process with a process mean that is
Continuing the previous problem, operators have made an adjustment that they hope will improve the functioning of this process. The file P20_04.xlsx contains 25 subsamples of 6 observations each on
Suppose that a product is composed of m identical and probabilistically independent parts. Assume that this product is manufactured through the use of a 6-sigma process with a process mean that is
Suppose that after monitoring a large number of electronic computer chips, a manufacturer observes that 1% of them are out of specifications. Assume that the process mean exceeds the target mean by
Suppose that after monitoring thousands of ball bearings, a manufacturer observes that 0.27% of them are out of spec. Assume that the process mean is 1.5 standard deviations below the target mean.
To monitor product quality, Wintel inspects 30 chips each week and determines the fraction of defective chips. The resulting data are in the file P20_43.xlsx. Construct a p chart based on 12 weeks of
Eleven samples of size 3 were taken in an effort to monitor the voltage held by a regulator. The data are in the file P20_44.xlsx. A regulator meets specifications if it can hold between 40 and 60
You are the manager of a hospital emergency room. You are interested in analyzing the time patients wait to see a physician. For 25 samples of 5 patients each, the file P20_45.xlsx contains the time
A mail-order company (Seas Beginning) processes 100 invoices per day. For each of several days, they have kept track of the number of invoices that contain errors. The data are in the file
The file P20_47.xlsx contains the measured diameters (in inches) reported by the production foreman of 500 rods produced by Rodco. A rod is considered acceptable if it is at least 1.0 inch in
John makes 20 computers per day for Pathway computer. Production data appear in the file P20_48.xlsx. Construct a control chart based on the number of defective computers produced during each of the
USL = 1.06 inches and LSL = 0.94 inch.a. Is the process in control? If it is out of control, describe any observed out-of-control pattern.b. If possible, estimate Cp, Cpk, and the probability of
Producers of a particular brand of ready-to-eat breakfast cereal place, in theory, 15 ounces of cereal in each box of this product. In an effort to assess this stage of the manufacturing process, an
For the data in the file P20_50.xlsx, suppose that LSL = 190 and USL = 210.a. Is the process in control? If it is out of control, describe any observed out-of-control pattern.b. If possible, estimate
For the data in the file P20_51.xlsx, suppose that LSL = 195 and USL = 205.a. Is the process in control? If it is out of control, describe any observed out-of-control pattern.b. If possible, estimate
Consider a k-sigma process.a. If k = 4, determine the fraction of all parts that meet specifications and calculate Cp. Now suppose that a car consists of 1000 parts, each of which is governed by a
A part is considered within specifications if its tensile strength is between 180 and 200. For 20 straight hours the tensile strength of 4 randomly chosen parts was measured. The data are in the file
Twelve samples of size 4 were taken in an effort to monitor the voltage held by a regulator. The data are in the file P20_54.xlsx. A regulator meets specifications if it can hold between 18 and 56
Suppose that the employees of D&D's each service 100 accounts per week. The file P20_55.xlsx contains the number of accounts that each employee "messed up" during the week. Do these data indicate
Continuing the previous problem, the file P20_56.xlsx contains 2 more weeks of data for D&D's.a. By plotting each employee's weekly fraction of "mess ups," does it appear that Amanda is a
The data in the file P20_06.xlsx consist of 25 subsamples of 4 observations each on the lengths of particular bolts manufactured for use in large aircraft. The target length of these bolts is 37
Showing 75100 - 75200
of 82267
First
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
Last