Explain why math is important in each case and illustrate your point by using math in some examples.

Choose one topic to write about
Home Improvement – Pick a home improvement project that interests you and identify at least 3 ways math is important when calculating the materials, labor, and budget needed for that project. Explain why math is important in each case and illustrate your point by using math in some examples.

Travel and Lodging – Pick a trip that interests you and identify at least 3 ways math is important when planning and budgeting for that trip. Explain why math is important in each case and illustrate your point by using math in some examples.

Saving and Investing – Pick an investment that interests you and identify at least 3 ways math is important when evaluating the costs and potential returns of that investment. Explain why math is important in each case and illustrate your point by using math in some examples.

Provide the confidence interval, the p-value, and your results using the 5-step hypothesis testing method.

Hypothesis testing **= most important

I. You chose your questions based on a poll. How did your sample compare to the
national poll?
Choose three questions from your poll and conduct a hypothesis test on each
question.
Provide the confidence interval, the p-value, and your results using the 5-step
hypothesis testing method.
IV. What did you find? Did your poll mirror the national poll? Why or why not?

 

Explain why math is important in each case and illustrate your point by using math in some examples.

Choose one topic to write about
Home Improvement – Pick a home improvement project that interests you and identify at least 3 ways math is important when calculating the materials, labor, and budget needed for that project. Explain why math is important in each case and illustrate your point by using math in some examples.

Travel and Lodging – Pick a trip that interests you and identify at least 3 ways math is important when planning and budgeting for that trip. Explain why math is important in each case and illustrate your point by using math in some examples.

Which would be the independent variable, and which would be the dependent variable? Without drawing a scatter plot, would you expect a positive, negative or no correlation? Explain.

Read/review the following resources for this activity:

Textbook: Chapter 12
Lesson
Minimum of 1 scholarly source
Initial Post Instructions

Medical professionals can find relationships between variables. The more you drink alcohol, the less functionality of your liver. The less carbohydrates a person intakes, the lower their Body Mass Index.

Data can be collected and organized as an ordered pair (x, y). The data can be analyzed to determine the type and strength of a correlation and to calculate a regression line in order to make a prediction.

Use the internet to find a data set of ordered pairs. Key terms to search: Free Public Data Sets and Medical Data Sets.

Create a Post:

Introduce your Data Set and Cite the Source.

Which would be the independent variable, and which would be the dependent variable?
Without drawing a scatter plot, would you expect a positive, negative or no correlation? Explain.
Would you categorize your data to have a strong or weak correlation? Why?
What would the r2 value tell you about the data that you selected?
What is the equation of the regression line?
Use the regression line to make a prediction about the data you collected.

What is the level of measurement for each of the variables?What patterns, if any have you noticed about your data?

Exploratory Data Analysis and Descriptive Statistics
I. Provide all TABLES AND GRAPHS for your data
A. These must include the following:

i. Classify EACH variable as qualitative or quantitative.
ii. Classify the quantitative variable as discrete or continuous.
iii. Frequency distribution for all of the variables.
iv. Relative frequency distribution for all of the variables.
v. Histogram for each of the quantitative variables.
vi. An ogive for the quantitative variables.
vii. What is the level of measurement for each of the variables?

b. What patterns, if any have you noticed about your data? This is particularly
important when analyzing the level of educational attainment and responses to other questions.

c. Provide descriptive statistics for all the variables in your sample. Remember,
you are only describing your data.

d. What did you find out about your data?

 

Calculate your average using the weighted values . Note that your average should change as any grade is changed throughout the spreadsheet.

Project 2 Gradebook

⦁ Read through the syllabus to find the weights for each of the grade categories we have.Record these values with a description somewhere on your spreadsheet.
⦁ Make a column that lists each homework assignment for the semester and fill in values for your current grades. Calculate the average for this column
⦁ Create a space on the spreadsheet to add values for your project grades, quizzes, midterm grade, and final exam.
⦁ Calculate your average using the weighted values . Note that your average should change as any grade is changed throughout the spreadsheet.
⦁Format the information as needed to make it “reader friendly”. Use various colors, borders, etc so that your sheet isn’t just a table of numbers. Make sure the final average is easy to find and distinguishable from the other data.
On the second sheet, you are to make a table of values that calculates a student’s GPA. See this website for a brief description on calculating GPA: http://www.back2college.com/gpa.htm

Create a space on the spreadsheet to add values for your project grades, quizzes, midterm grade, and final exam.

For this assignment you will be making a gradebook that will keep your average calculated throughout the semester. You will make this project in Microsoft Excel and will be graded on not only accuracy, but also formatting.
⦁ We will be using two “sheets” on this assignment. Label sheet one as “Gradebook” create a second sheet and name it “GPA”.

⦁ Read through the syllabus to find the weights for each of the grade categories we have. Record these values with a description somewhere on your spreadsheet.
⦁ Make a column that lists each homework assignment for the semester and fill in values for your current grades. Calculate the average for this column .
⦁  Create a space on the spreadsheet to add values for your project grades, quizzes, midterm grade, and final exam.
⦁ Calculate your average using the weighted values . Note that your average should change as any grade is changed throughout the spreadsheet.
⦁ Format the information as needed to make it “reader friendly”. Use various colors, borders, etc so that your sheet isn’t just a table of numbers. Make sure the final average is easy to find and distinguishable from the other data.

 Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Yellow fill color to those cells.

Complete the single variable data table in the range D5:F15. Be sure to use total square footage as the column input. Apply custom number formats to display Base Cost in cell E5 and Total Cost in cell F5. Apply these formats to the headings: bold, center, and Blue font color.
Identify the square footage, base price, and total cost in the data table that comes closest to their goal. Apply Yellow fill color to those cells.
Copy the square footage substitution values, range D6:D15 to the range H6:H15 and remove the fill color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero decimal places and Blue font color.
Enter the reference to the total estimated cost in the appropriate location for the second data table. Apply a custom number format to display Total Sq Ft in that cell. Apply Blue font and bold to that cell.

Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents by the deduction per dependent and subtract that from the gross pay.

As manager of the gift shop at the Metropolitan Zoo, you are responsible for managing the weekly payroll. Your assistant developed a partial worksheet, but you need to enter the formulas to calculate the regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay. In addition, you want to include total pay columns and calculate some basic statistics. As you construct formulas, make sure you use absolute and relative cell references correctly in formulas.

Steps to Perform:
Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch02_ML1_Payroll.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40. 20
3 Create a formula in cell H5 to calculate the taxable pay. Multiply the number of dependents by the deduction per dependent and subtract that from the gross pay. With two dependents, Abram’s taxable pay is $417.40. 10
4 Use a VLOOKUP function in cell I5 to identify and calculate the federal withholding tax. Use the tax rates from the range D21:E25. The VLOOKUP function returns the applicable tax rate, which you must then multiply by the taxable pay. 20
5 Calculate FICA in cell J5 based on gross pay and the FICA rate , and calculate the net pay in cell K5. Copy all formulas down their respective columns to row 16. 10

Discuss your rationale for your choice of the real-world optimization problem. How were you able to identify that it was an example of the CPP? Why is this example relevant?

Chinese Postman Problem
For this Critical Thinking assignment, you will solve a real-world optimization problem using graph theory.

Part I: Complete the following steps:

Select a real-world optimization problem that is an example of the Chinese Postman Problem .
Create a graph modeling the real-world scenario corresponding to the problem. Use weights to represent the variable that you are optimizing.
Find an optimal solution for the problem using the concepts studied in this module.
Part II: Based on your work in Part I, discuss the following:

Discuss your rationale for your choice of the real-world optimization problem. How were you able to identify that it was an example of the CPP? Why is this example relevant?
Describe how you created the graph modeling the real-world scenario corresponding to the problem.
Identify if the graph has a Euler path and a Euler circuit. Justify your answer.