03.30Homework Set 2

docx

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

Report
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.