03.30Homework Set 2
docx
keyboard_arrow_up
School
Utah State University *
*We aren’t endorsed by this school
Course
3100
Subject
Statistics
Date
Apr 3, 2024
Type
docx
Pages
7
Uploaded by DrMetal9439
DATA 3100 | Making Decisions with Data
Module 3: Homework Set 2 + Excel Set 1
Name:
Homework Set 2
Answer the below problems from the textbook – either in Excel or by hand (paste in images). See Canvas
for more details.
2.1
2.2
2.3
DATA 3100 | Making Decisions with Data
Module 3: Homework Set 2 + Excel Set 1
2.18
2.20
DATA 3100 | Making Decisions with Data
Module 3: Homework Set 2 + Excel Set 1
2.21
2.30
Excel Set 1
Using Excel, answer the below problems from the textbook. Provide your written responses and
screenshots from your Excel file. Upload both your Excel file and this completed document to the Canvas assignment page by its due date/time.
2.8
After reading Exercise 2.8 in the text, you will need to copy the table shown in the textbook into Excel in the first worksheet (Sheet 1) to answer the questions in 2.8.
2.8A
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
DATA 3100 | Making Decisions with Data
Module 3: Homework Set 2 + Excel Set 1
The highest frequency bot in relative terms and not seem to come from the WLAN/Single attacks. WLAN is both capacities show about 60% of relative frequency overall.
2.8B
2.13
2.13A
2.13B
DATA 3100 | Making Decisions with Data
Module 3: Homework Set 2 + Excel Set 1
2.13C
The gulf region shows the highest volume of fish, but the lowest value. This would conclude that both the Atlantic and pacific fish are more valuable per fish than the gulf.
2.14
After reading Exercise 2.14, you will need to copy the table shown in the textbook into Excel in the third worksheet (Sheet 3). Create a graph to answer Exercise 2.14 in Sheet 3 of your Excel workbook, then paste a screenshot of that graph here. Do you agree with the statement made in 2.14 based on the graph you created?
I disagree, this chart shows little variation in the different measurement indicators, showing that while there are a few different categories, no category is relatively more favored than others.
DATA 3100 | Making Decisions with Data
Module 3: Homework Set 2 + Excel Set 1
2.24 a-b
After reading Exercise 2.24, copy the dataset (SANIT.xlsx) on the Canvas assignment page into your Excel
worksheet (Sheet 4).
2.24A
2.24B
95% or 0.95
2.26 a-c
After reading Exercise 2.26, copy the dataset (NFL.xlsx) on the Canvas assignment page into your Excel worksheet (Sheet 5).
2.26A
The majority of the league is valued at 2,780 or less.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
DATA 3100 | Making Decisions with Data
Module 3: Homework Set 2 + Excel Set 1
2.26B
The majority of the teams have 50% or less value change in the last 1 year.
2.26C
A majority of the teams in the league have a debt/value ratio of .25 or less.
Related Documents
Related Questions
PLEASE HELP ME ANSWER THESE!
arrow_forward
Continue monitoring the process. A second ten days of data have been collected, see table labeled “2nd 10 Days of Monitoring Reservation Processing Time” in the Data File.
Develop Xbar and R charts for the 2nd 10 days of monitoring. Plot the data for the 2nd 10 days on the Xbar and R charts.
Is the reservation process for the 2nd 10 days of monitoring in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart.
Based on the X-bar and R Charts that you developed for the 2nd 10 days of data, is the process in control?
Group of answer choices
No. The X-bar and R Charts are both out of control.
No. The X-bar Chart is in control, but the R Chart is out of control.
No. The R Chart is in control, but the X-bar Chart is out of control.
Yes. The X-bar and R Charts are both in control.
arrow_forward
Identify several types of manufacturing companies for which process costing would be an appropriate product-costing system. What characteristics do the products of these companies have that would make process costing a good choice?
How is process costing similar and different in a second or later processing department?
arrow_forward
Part 2. Refer to the Excel file Cereal data set to complete the following tasks. All results and explanations need to be reported within this Word document after each question. Make sure to use complete sentences when explaining your results. Your results should be formatted and edited.
Data Set: Cereals
The data set shows the name of different brands of cereals, the manufacturers, the total calories, proteins, sugar, fat, potassium, sodium, location of the shelf in the supermarket, etc. The amount of sugar, protein, etc., is measured in grams (g).
Exercise 1:
A. Construct a frequency distribution and a bar graph for the cereal manufactures (mfr). Include the relative frequencies. Edit and format the graph and include appropriate labels for the horizontal and vertical axes. Describe your findings in the context of the problem (Include which manufacturer produces the most cereals and least number of cereals in the cereal market).
N = Nabisco, K = Kellog’s, Q = Quaker Oats…
arrow_forward
Plz help asap 40 need crit value as well
arrow_forward
Hi. Attached is the table for reference and the questions are right below. Please answer subparts #4-6. Thank you.
arrow_forward
please. help me answer this question. thank you
arrow_forward
The shipping department for a warehouse has noted that if 120packages are shipped during a month, the total expenses for the department are $1635. If 180 packages are shipped during a month, the total expenses for the shipping department are $1725. Let x represent the number of packages and y represent the total expenses for the shipping department. Answer the following questions.
Question content area bottom
Part 1
(a) Interpret the meaning of the point (120,1635) in the context of this problem.
A. When 120 packages are shipped, each package cost $1635.
B. When 1635 packages are shipped, the expenses are $120. C. When 120 packages are shipped, the expenses are $1635.
arrow_forward
The higher education department of Holmes Institute recorded data on the number of students enrolled in the different study majors for the years 2018 and 2019.
Study major
2018
2019
Statistics
1700
2250
Business law
700
900
Accounting
1300
1450
Economics
750
1000
Finance
1450
1758
Marketing management
1069
1189
Auditing
360
351
Use an appropriate graphical technique or chart to compare the number of enrolment in 2018 and 2019 of the different study major. Display the chart.
Use an appropriate graphical technique or chart to display the percentage value of the number of enrolment of the different study major in 2018 and 2019. Display the chart.
arrow_forward
I need assistance with parts a, b, and c.
Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrollment (in thousands) for Jefferson Community College for the nine most recent years. Click on the datafile logo to reference the data.
Year
Period (t)
Enrollment(1,000s)
2001
1
6.5
2002
2
8.1
2003
3
8.4
2004
4
10.2
2005
5
12.5
2006
6
13.3
2007
7
13.7
2008
8
17.2
2009
9
18.1
A. Choose the correct time series plot. What type of pattern exists in the data? Positive trend pattern or negative trend pattern
B. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places.
y-intercept, b0 =
Slope, b1 =
MSE=
C. What is the forecast for year 10? Do not round your interim computations and round your final answer to two decimal places.
arrow_forward
Please answer part b
arrow_forward
I need help with this problem please.
arrow_forward
need help with C
arrow_forward
Please help with (d)
arrow_forward
An economic organization tracks summary statistics of various countries. These include GDP (gross domestic product per capita) and trade balances (measured as a percentage of GDP).
Exporting countries tend to have large positive trade balances. Importers have negative balances. The data are shown in the accompanying table. Formulate the SRM with GDP as the response
and Trade Balance as the explanatory variable. Complete parts (a) through (c) below.
Click the icon to view the data table.
(a) Country X reported the highest positive balance of trade, 24.2% of GDP and per capita GDP equal to $63,000. Fit the least squares equation both with and without country X and compare the
results. Does the fitted slope change by very much?
Find the least squares equation without country X. Complete the equation below.
Estimated GDP ($ per cap) = ☐ ☐ Trade Bal (%GDP)
(Round to the nearest integer as needed.)
Data Table
- X
Trade Balance
(%GDP)
GDP
($ per capita)
-6.3
16,876
15.7
44,932
-0.9
9,334
-7.9…
arrow_forward
Suppose you need to summarize ordinal data in a bar graph. How would you arrange the categories of data on the horizontal axis? Is it possible to make the order of the data apparent in a pie chart?
arrow_forward
Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.
Charity #
Charity
Total Expenses ($)
Administrative Expenses (%)
Fundraising Expenses (%)
Program Expenses (%)
1
American Red Cross
3355147520
3.8
3.9
92.1
2
World Vision
1200410940
3.8
7.6
88.4
3
Smithsonian Institution
1078888839
23.3
2.6
73.7
4
Food For…
arrow_forward
Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Construct a spreadsheet to answer the following questions.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning

Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL

Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Related Questions
- PLEASE HELP ME ANSWER THESE!arrow_forwardContinue monitoring the process. A second ten days of data have been collected, see table labeled “2nd 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 2nd 10 days of monitoring. Plot the data for the 2nd 10 days on the Xbar and R charts. Is the reservation process for the 2nd 10 days of monitoring in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart. Based on the X-bar and R Charts that you developed for the 2nd 10 days of data, is the process in control? Group of answer choices No. The X-bar and R Charts are both out of control. No. The X-bar Chart is in control, but the R Chart is out of control. No. The R Chart is in control, but the X-bar Chart is out of control. Yes. The X-bar and R Charts are both in control.arrow_forwardIdentify several types of manufacturing companies for which process costing would be an appropriate product-costing system. What characteristics do the products of these companies have that would make process costing a good choice? How is process costing similar and different in a second or later processing department?arrow_forward
- Part 2. Refer to the Excel file Cereal data set to complete the following tasks. All results and explanations need to be reported within this Word document after each question. Make sure to use complete sentences when explaining your results. Your results should be formatted and edited. Data Set: Cereals The data set shows the name of different brands of cereals, the manufacturers, the total calories, proteins, sugar, fat, potassium, sodium, location of the shelf in the supermarket, etc. The amount of sugar, protein, etc., is measured in grams (g). Exercise 1: A. Construct a frequency distribution and a bar graph for the cereal manufactures (mfr). Include the relative frequencies. Edit and format the graph and include appropriate labels for the horizontal and vertical axes. Describe your findings in the context of the problem (Include which manufacturer produces the most cereals and least number of cereals in the cereal market). N = Nabisco, K = Kellog’s, Q = Quaker Oats…arrow_forwardPlz help asap 40 need crit value as wellarrow_forwardHi. Attached is the table for reference and the questions are right below. Please answer subparts #4-6. Thank you.arrow_forward
- please. help me answer this question. thank youarrow_forwardThe shipping department for a warehouse has noted that if 120packages are shipped during a month, the total expenses for the department are $1635. If 180 packages are shipped during a month, the total expenses for the shipping department are $1725. Let x represent the number of packages and y represent the total expenses for the shipping department. Answer the following questions. Question content area bottom Part 1 (a) Interpret the meaning of the point (120,1635) in the context of this problem. A. When 120 packages are shipped, each package cost $1635. B. When 1635 packages are shipped, the expenses are $120. C. When 120 packages are shipped, the expenses are $1635.arrow_forwardThe higher education department of Holmes Institute recorded data on the number of students enrolled in the different study majors for the years 2018 and 2019. Study major 2018 2019 Statistics 1700 2250 Business law 700 900 Accounting 1300 1450 Economics 750 1000 Finance 1450 1758 Marketing management 1069 1189 Auditing 360 351 Use an appropriate graphical technique or chart to compare the number of enrolment in 2018 and 2019 of the different study major. Display the chart. Use an appropriate graphical technique or chart to display the percentage value of the number of enrolment of the different study major in 2018 and 2019. Display the chart.arrow_forward
- I need assistance with parts a, b, and c. Because of high tuition costs at state and private universities, enrollments at community colleges have increased dramatically in recent years. The following data show the enrollment (in thousands) for Jefferson Community College for the nine most recent years. Click on the datafile logo to reference the data. Year Period (t) Enrollment(1,000s) 2001 1 6.5 2002 2 8.1 2003 3 8.4 2004 4 10.2 2005 5 12.5 2006 6 13.3 2007 7 13.7 2008 8 17.2 2009 9 18.1 A. Choose the correct time series plot. What type of pattern exists in the data? Positive trend pattern or negative trend pattern B. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 = Slope, b1 = MSE= C. What is the forecast for year 10? Do not round your interim computations and round your final answer to two decimal places.arrow_forwardPlease answer part barrow_forwardI need help with this problem please.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Elementary Geometry for College StudentsGeometryISBN:9781285195698Author:Daniel C. Alexander, Geralyn M. KoeberleinPublisher:Cengage LearningHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALMathematics For Machine TechnologyAdvanced MathISBN:9781337798310Author:Peterson, John.Publisher:Cengage Learning,

Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning

Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL

Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,