Introduction to Data Analysis Using Excel Coursera Quiz Answers 2022 | All Weeks Assessment Answers [💯Correct Answer]

by
Introduction to Data Analysis Using Excel Coursera Quiz Answers 2022 | All Weeks Assessment Answers [💯Correct Answer]
Table of Contents

Hello Peers, Today we are going to share all week’s assessment and quizzes answers of the Introduction to Data Analysis Using Excel course launched by Coursera totally free of cost✅✅✅. This is a certification course for every interested student.

In case you didn’t find this course for free, then you can apply for financial ads to get this course for totally free.

Check out this article – “How to Apply for Financial Ads?”

About The Coursera

Coursera, India’s biggest learning platform launched millions of free courses for students daily. These courses are from various recognized universities, where industry experts and professors teach in a very well manner and in a more understandable way.

Here, you will find Introduction to Data Analysis Using Excel Exam Answers in Bold Color which are given below.

These answers are updated recently and are 100% correct✅ answers of all week, assessment, and final exam answers of Introduction to Data Analysis Using Excel from Coursera Free Certification Course.

Use “Ctrl+F” To Find Any Questions Answer. & For Mobile User, You Just Need To Click On Three dots In Your Browser & You Will Get A “Find” Option There. Use These Option to Get Any Random Questions Answer.

About Introduction to Data Analysis Using Excel Course

he use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This is an introductory course in the use of Excel and is designed to give you a working knowledge of Excel with the aim of getting to use it for more advance topics in Business Statistics later. The course is designed keeping in mind two kinds of learners – those who have very little functional knowledge of Excel and those who use Excel regularly but at a peripheral level and wish to enhance their skills. The course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to some of the more advanced functionality of Excel. All along, Excel functionality is introduced using easy to understand examples which are demonstrated in a way that learners can become comfortable in understanding and applying them.

To successfully complete course assignments, students must have access to a Windows version of Microsoft Excel 2010 or later.

WEEK 1 Module 1: Introduction to Spreadsheets In this module, you will be introduced to the use of Excel spreadsheets and various basic data functions of Excel. Topics covered include: • Reading data into Excel using various formats • Basic functions in Excel, arithmetic as well as various logical functions • Formatting rows and columns • Using formulas in Excel and their copy and paste using absolute and relative referencing ________________________________________

WEEK 2 Module 2: Spreadsheet Functions to Organize Data This module introduces various Excel functions to organize and query data. Learners are introduced to the IF, nested IF, VLOOKUP, and the HLOOKUP functions of Excel. Topics covered include: • IF and the nested IF functions • VLOOKUP and HLOOKUP • The RANDBETWEEN function ________________________________________

WEEK 3 Module 3: Introduction to Filtering, Pivot Tables, and Charts This module introduces various data filtering capabilities of Excel. You’ll learn how to set filters in data to selectively access data. A very powerful data summarizing tool, the Pivot Table, is also explained and we begin to introduce the charting feature of Excel. Topics covered include: • VLOOKUP across worksheets • Data filtering in Excel • Use of Pivot tables with categorical as well as numerical data • Introduction to the charting capability of Excel ________________________________________

WEEK 4 Module 4: Advanced Graphing and Charting This module explores various advanced graphing and charting techniques available in Excel. Starting with various line, bar, and pie charts we introduce pivot charts, scatter plots, and histograms. You will get to understand these various charts and get to build them on your own. Topics covered include • Line, Bar, and Pie charts • Pivot charts • Scatter plots • Histograms

Course Apply Link – Introduction to Data Analysis Using Excel

Introduction to Data Analysis Using Excel Quiz Answers

Week 1 Quiz Answers

Quiz 1: Reading Data into Excel

Q1. The chart shows text data for Columns A-D
The format shown in the example above is:

  • Comma delimited
  • Space delimited
  • Tab delimited
  • Fixed width

Q2. The chart shows text data for Columns A-D
The format shown in the example above is:

  • Comma delimited
  • Space delimited
  • Tab delimited
  • Semicolon delimited

Quiz 2: Basic Data Manipulation in Excel

Q1. To move to the edge of the current data region, press:

  • Page Up/Down key
  • CTRL + arrow key
  • ALT + arrow key
  • Home/End key

Q2. Columns A, B and C have entries for Serial Number, Part Number and Revision respectively;
The data above is sorted:

  • First by Part Number, then by Revision.
  • First by Revision, then by Part Number.
  • First by Serial Number, then by Revision.
  • First by Revision, then by Serial Number.

Quiz 3: Arithmetic Manipulation in Excel

Q1. Typing which of the following into a cell would result in a cell value of 3?

  • 1,2
  • 1+2
  • =1,2
  • =1+2

Q2. A1-C3 have integers 1-9 in increasing order left-right
Using the data in the example above, what is the value of the following formula?

=A3+C1

Enter answer here

Quiz 4: Basic Functions in Excel

Q1. The figure shows a table with numbers 1-9 in increasing order left-right in 3X3 matrix
In the example above, typing which of the following into a cell would result in a cell value of 3? Select all that apply.

  • =1+2
  • =SUM(1,2)
  • =SUM(A1,B1)
  • =SUM(A1:B1)

Q2. Columns A and B have data entries; SUMIF() function inputs and parameters are shown below
In the example above, what would be the calculated value of the SUMIF statement in cell A5?

Enter answer here

Quiz 5: Functions Using Absolute and Relative References

Q1. Which symbol is used in a formula to “fix” a row or a
column reference?

  • #
  • $
  • %
  • &

Q2. What would be the calculated value of the following
formula?

=MAX(1,4,2,8,5)

Enter answer here

Quiz 6: Functions Explained

Q1. The table on left is blank while table on right shows the desired output
Let’s say you want each blank cell to equal its row header multiplied by its column header, as shown above. Which of the following cell B2 formulas would give the correct result when pasted into the remaining empty cells?

  • =A2*B1
  • =$A2*B$1
  • =A$2*$B1
  • =$A$2*$B$1

Q2. If you want to always reference cell C5 in a formula,
even when that formula is copied down rows or across columns, the reference to
cell C5 should be written as:

  • C5
  • $C5
  • C$5
  • $C$5

Quiz 7: Introduction to Spreadsheets

Q1. Download the file “Store Sales 2011.txt” (you may need to right-click and select “save link as…”) Use the data in this file for the remainder of the assignment. Note that the date in the file is in the mm/dd/yyyy format, so while reading it into Excel please be vary of that.

The format used in the “Store Sales 2011.txt” file is:

  • Space delimited
  • Comma delimited
  • Tab delimited
  • Fixed width

Q2. Import the file into Excel using the correct file format from the previous question. How many rows of data does the file contain?

Hint: Do not count the top (header) row.

Enter answer here

Q3. Sort the data by Order Date (oldest to newest) and then
by Order Quantity (largest to smallest).
After the data is sorted, what is the Order ID of the order in the 3rd row of data (i.e. spreadsheet row 4)?

Enter answer here

Q4. Using cell references, how could you calculate the unit price of the order in the first row of data?

  • =D2/E2
  • =E2/D2
  • =21/845.32
  • =845.32/21

Q5. Insert a new column to the right of the “Sales” column, and type the name “Unit Price” as the header. Using cell references, calculate the unit price of the order in the first row, then copy and paste that formula down to the remaining rows.

Rounded to 2 decimal places, what is the Unit Price of the last row of data? (Do not include a dollar sign or commas in your answer)

Enter answer here

Q6. What is the largest Unit Price in this dataset?
Hint: Use the MAX() function here.

Enter answer here

Q7. How many orders were sent by Delivery Truck? Assume each line is counted as a single order.

Hint: Use the COUNTIF() function here.

Enter answer here

Q8. What is the total shipping cost of all orders sent by Delivery Truck?

Hint: Use the SUMIF() function here.

Enter answer here

Q9. If you wanted to know the range, or the difference
between the highest and lowest value, of the shipping costs in this dataset, which
formula could you use?

  • =MAX(H2:H2003)-MIN(H2:H2003)
  • =SUM(H2:H2003)
  • =MIN(H2003)-MAX(H2003)
  • None of the Above

Q10. What is the average shipping cost (to 2 decimal places) of all orders sent by Delivery Truck?

Hint: Calculate the average by taking total cost divided by number of orders.

Enter answer here

Week 2 Quiz Answers

Quiz 1: The “IF” Command in Excel

Q1. Remember: IF(logical_test, [value_if_true], [value_if_false])

Table shows A1, A2, A3 entries as dog, cat, rabbit respectively
Using the table above, what would be the result of the
following formula?

=IF(A1=“dog”, “bark”, “no bark”)

Enter answer here

Q2. Select all statements below that are true.

  • =IF(1=2, “incorrect”, “correct”)
    • returns: incorrect
  • =IF(TRUE, “yes”, “no”)
    • returns: yes
  • =IF(“apples”=”oranges”, “same”, “different”)
    • returns: different
  • =IF(A1>A1, “low”, “high”)
    • returns: low

Quiz 2: The “IF” Command in Excel Using Numerical Data

Q1. Given the formula

=IF(A1>1000, 1000, A1)

Which of the following is true?

  • If the value of A1 is -20, the formula will return 1000.
  • If the value of A1 is 2000, the formula will return 2000.
  • No matter the value of A1, the lowest value this formula will return is 0.
  • No matter the value of A1, the highest value this formula will return is 1000.

Q2. A1-C3 have integers 1-9; the IF() function entries are shown on the right
Assume the formula shown above was entered into cell D1, then copied down to D2 and D3. The resulting values in cells D1, D2, and D3 would be:

  • small, small, small
  • small, small, large
  • small, large, large
  • large, large, large

Quiz 3: The “Nested IF” Command in Excel

Q1. The formula

=IF(FALSE, 1, IF(TRUE, 2, 3))

will return:

  • 1
  • 2
  • 3
  • Error

Q2. Given the formula

=IF(A1<10, “low”, IF(A1<20, “middle”, “high”))

If the value of A1 is 10, what will the formula return?

Enter answer here

Quiz 4: The “VLOOKUP” Function in Excel

Q1. Rows 1, 2 and 3 have entries for Apples, Bananas and Candy respectively; VLOOKUP entries and input parameters are shown below
What will the VLOOKUP formula return?

Enter answer here

Q2. practice quizA6-A9 have entries- Apples, Bananas, Candy, Apples (in that order) VLOOKUP entries and input parameters are shown on the right
What will the VLOOKUP formula return?

Enter answer here

Quiz 5: Another “VLOOKUP” Example

Q1. Columns A and B have entries for size and label respectively; VLOOKUP entries and input parameters are shown on the right
What will the VLOOKUP formula return? Note the last parameter.

  • S
  • M
  • L
  • XL
  • #N/A

Q2. Columns A and B have entries for size and label respectively; VLOOKUP entries and input parameters are shown on the right
What will the VLOOKUP formula return? Note the last parameter.

  • S
  • M
  • L
  • XL
  • #N/A

Quiz 6: The “HLOOKUP” Function in Excel

Q1. practice quizColumns A, B and C have entries for Apples, Bananas and Candy respectively; HLOOKUP entries and input parameters are shown below
What will the HLOOKUP formula return?

Enter answer here

Q2. Rows 1 and 2 have entries for Size and Label respectively; HLOOKUP entries and input parameters are shown below
What will the HLOOKUP formula return?

  • S
  • M
  • L
  • XL
  • #N/A

Quiz 7: Professor ‘Know-it-all’ Needs Help!

Q1. Professor ‘Know-it-all’ wants to implement another system to call upon a group of students at random. She has created 4 groups:

Group 1: Students 1-5 Group 2: Students 6-10 Group 3: Students 11-15 Group 4: Students 16-20

Her VLOOKUP function does not correctly return a random group. What is wrong with her function below?

practice quizColumns A and B have entries for S.No and Group Name respectively; VLOOKUP entries and input parameters are shown on the right.

  • The lookup_value parameter should be “RANDBETWEEN(1,16)”.
  • The table_array parameter should be “A3:B6”.
  • The col_index_num parameter should be “1”.
  • The [range_lookup] parameter should be “TRUE”.

Q2. You
inform Professor K. that a much simpler solution to her problem above would be
to just use the RANDBETWEEN function to randomly return a value of 1, 2, 3, or
4 directly. Which of the following would correctly
implement this solution?

  • =RANDBETWEEN(1,4)
  • =RANDBETWEEN(1,16)
  • =RANDBETWEEN(1,20)
  • =RANDBETWEEN(0,5)

Quiz 8: Spreadsheet Functions to Organize Data

Q1. Download the spreadsheet “Store Sales 2012.xlsx” below. Use the data in this spreadsheet for the remainder of the assignment.

The formula in cell H2 contains a referencing error that must be fixed before copying the formula down the column. If the formula were to be copied down the column without making any corrections, which of the following would be true?

  • The formula would always return “Small”
  • The formula would always return “Medium”
  • The formula would always return “Large”
  • The formula would only return “Large” or “Small”

Q2. Assuming you want the formula in H2 to always reference the cell directly to its left, correct the formula. Once the formula is fixed, copy the formula down the column. What is the “Order Type” of Order ID 11428, placed on 1/21/2012?

  • Small
  • Medium
  • Large
  • Extra Large

Q3. The boss decides that using only 3 levels—small, medium, and large—does not give the shipping department enough information. She wants to use the 10 levels shown in Lookup Table 1 (A3:B12). Write a formula in the “Expanded Order Type” column to assign the correct type to each order by “Order Quantity.” Copy the formula down to all the rows. Based on the layout of Lookup Table 1, should you use a VLOOKUP function or an HLOOKUP function?

  • VLOOKUP
  • HLOOKUP

Q4. Using your newly created “Expanded Order Type” column, calculate the total “Sales” for all orders of “Medium” type (rounded to 2 decimal places). Hint: The SUMIF() function is useful here.

Enter answer here

Q5. The company gives a 1% discount on any Extra Large or larger orders. In the “Discount” column, create a formula that returns 0.01 if the “Expanded Order Type” is Extra Large, XX Large, or XXX Large, and returns 0 otherwise. You can accomplish this by using a (select all that apply):

  • VLOOKUP formula
  • HLOOKUP formula
  • Nested IF formula
  • A single IF formula (without additional formulae)

Q6. Create the formula from the previous question and copy the formula down to all the rows. How many orders will have a discount applied?

Hint: The COUNTIF() function is useful here.

Enter answer here

Q7. The “Sales with Discount” can be calculated by applying the discount to the original “Sales” entry:

Sales with Discount = Sales – (Sales * Discount)

or

Sales with Discount = Sales * (1 – Discount)

Create a formula in the “Sales with Discount” column and copy it down to all the rows. What is the impact of the discount on total sales in 2012? In other words, what is the difference between the sum of the “Sales” and the sum of the “Sales with Discount” (rounded to 2 decimal places)?

Enter answer here

Q8. Currently, customers are responsible for paying the shipping costs. The sales team suggests that customers really dislike paying shipping costs, and that offering “free shipping” instead of the 1% discount would likely increase sales. Create a formula for the “Sales with Free Shipping” column that subtracts the “Shipping Cost” from the “Sales” only if the “Expanded Order Type” is Extra Large, XX Large, or XXX Large. Copy the formula down to all the rows. What would total 2012 sales have been if the company had offered free shipping instead of the 1% discount (rounded to 2 decimal places)?

Enter answer here

Q9. How much money would the company have saved in 2012 if it had offered free shipping instead of the 1% discount on Extra Large, XX Large, or XXX Large orders (rounded to 2 decimal places)?

Enter answer here

Q10. What would 2012 total “Sales” have been if the company had offered free shipping on any order shipped by Delivery Truck, and no additional discounts (rounded to 2 decimal places)?

Enter answer here

Week 3 Quiz Answers

Quiz 1: Using the “VLOOKUP” Function Across Worksheets

Q1. Second sheet in the VLOOKUP function is referred to as “Sheet 2”
Second sheet in the image is labelled as “Item Pricing”
The VLOOKUP function above is intended to return the price from the second worksheet, but it has been incorrectly entered. To fix it, ‘Sheet 2’ should be replaced by:

  • ‘Sheet 1’
  • ‘Sheet_2’
  • ‘Recipe’
  • ‘Item Pricing’

Q2. Once the function above is corrected, what value will it return?

Enter answer here

Quiz 2: Data Filtering in Excel

Q1. Based on the dropdown symbol, which of the following has some sort of filtering applied? Select all that apply.

  • The filter dropdown button to the right of “Animal” has a funnel icon
  • The filter dropdown button to the right of “Animal” has a funnel icon
  • The filter dropdown button to the right of “Animal” has a funnel icon
  • None of the above

Q2. The last row with mouse is #45 and the first entry in the column is “Animal”
The column above is filtered to only show “Mouse” entries. If the column were NOT filtered, how many total Animal entries would there be? Hint: Don’t forget that the heading row does not count as an entry.

Enter answer here

Quiz 3: Use of Pivot Tables in Excel

Q1. the question explains the graphic
To set up a Pivot Table with years listed vertically as shown above, the Year field should be dragged into the following Pivot Area:

  • FILTERS
  • COLUMNS
  • ROWS
  • VALUES

Q2. the question explains the graphic
To set up a Pivot Table with years listed horizontally as shown above, the Year field should be dragged into the following Pivot Area:

  • FILTERS
  • COLUMNS
  • ROWS
  • VALUES

Quiz 4: More Pivot Table Options

Q1. In the Pivot Table above, in which pivot table field area was the Gender column used? Select all that apply.

  • FILTERS
  • COLUMNS
  • ROWS
  • VALUES

Q2. In 1992, how many women participated in the sport of gymnastics?

Enter answer here

Quiz 5: Application of Pivot Tables to Numeric Data

Q1. The chart shows the pivot table output
Which of the following would have created the Pivot Table above?

  • Columns-Product Category and Rows- Product Container
  • Filter-Product Category, Rows- Product container and Columns-Shipping Cost
  • Columns-Product Category, Rows- Product container and Values-Average of Shipping Cost
  • Filter-Product Category, Rows- Product container and Values-Sum of Shipping Cost

Q2. Which of the following is true about Pivot Tables? Select all that apply.

  • Editing a Pivot Table will impact the original data source.
  • Pivot Tables can be filtered by multiple columns.
  • Pivot Tables automatically calculate grand totals of rows and columns.
  • Dates in a Pivot Table can be grouped by years, quarters, months, days, hours, minutes, and seconds.

Quiz 6: Introduction to Charts in Excel

Q1. For months 7-9, the range for Dataset A is (-42,20), B is (-90,0) and C is (50,70)
The Line Chart above shows the data trends for three different datasets. Which dataset has the highest values for the months in the 3rd quarter of the year (months 7, 8, and 9)?

  • Dataset A
  • Dataset B
  • Dataset C
  • No data is shown for the 3rd quarter of the year

Q2. The table shows monthly distributions (rows) of Datasets A, B and C (columns)
The Line Chart in the previous question was created using the data above. How could you update the Line Chart to use the month names (A2:A13) instead of numbers on the horizontal axis?

  • Right-click on the chart, choose “Select Data…,” and select:
  • The first button to the right is to edit Dataset on x-axis
  • The button on center top is to switch axes
  • The second button to the left is to edit the y-axis data
  • The last button to the left is to add Datasets to y-axis

Quiz 7: Introduction to Filtering, Pivot Tables, and Charts

Q1. Download the spreadsheet “Store Sales 2009.xlsx” below. Use the data in this spreadsheet for the remainder of the assignment.

The “Compiled Information” tab was created to pull in the data from the other tabs using formulas. The formula in the “Shipping Cost” column was entered incorrectly. Fix the formula in cell D3, then re-copy the correct formula down to the remaining rows. What was the problem with the original formula?

  • The formula did not reference the correct tab.
  • The formula should use a locked reference for the table_array parameter.
  • The formula should use a locked reference for the lookup_value parameter.
  • The formula should be written with the HLOOKUP function.

Q2. On the “Compiled Information” tab, a VLOOKUP formula has been pre-entered into cell E3. This formula was written correctly, and it uses references to the numbers in cells E1 through G1 to determine the correct index_number parameter. Fill in cells F1 and G1 with the correct index numbers, then copy the formula in cell E3 down to all the rows in columns E, F, and G. What number did you enter into cell G1?

Enter answer here

Q3. Now that the data is updated, create a pivot table that contains all of the data on the “Compiled Information” tab. Using the PivotTable Fields side bar, drag the “Unique ID” field to the VALUES area and summarize the information by Count. What is the Count of Unique ID?

Enter answer here

Q4. Update the pivot table to show “Order Date” grouped by month. Drag the “Sales” field into the correct area to show the Sum of Sales for each of the months listed. Which month had the lowest sales? (Your answer should be the name of the month.)

Hint: Remember that you can sort the data once it is in the pivot table!

Enter answer here

Q5. Continuing from the previous question, update the pivot
table to show the Average of Sales by month.
Which month had the highest average? (Your answer should be the name of the month.)

Enter answer here

Q6. Which Customer Segment contained the single order with the highest shipping cost?

  • Consumer
  • Corporate
  • Home Office
  • Small Business

Q7. In the Corporate Customer Segment, what was the most
common order quantity?

Enter answer here

Q8. In all segments, how many orders were placed in one quarter of the year but shipped in the next quarter (For example, an order in which Order Date = Qtr1 2009 and Ship Date = Qtr2 2009)?

Enter answer here

Q9. Create a line chart that shows the average of “Sales” for each customer segment by month, where each customer segment is represented by a line on the chart. Which of the following line charts shows the average sales data?

  • The range on y-axis is 0-6000 with scale of 1000 units
    .
  • The range on y-axis is 0-200000 with scale of 20000 units
    .
  • The range on y-axis is 0-50 with scale of 5 units
    .
  • The range on y-axis is 0-100 with scale of 10 units
    .

Q10. The line chart shown follows a zig-zag pattern with decreasing peaks left-right
Line charts are useful for looking for trends in data and gaining quick insights. The chart above shows total Sales in 2009 by month in the Consumer segment. Which of the following could be inferred from the chart? Select all that apply.

  • Month to month sales numbers are relatively volatile (>10% difference in sales compared to previous month).
  • In 2009, March and April were the months with the highest total sales.
  • In general, total sales numbers continued to rise
    throughout 2009.
  • In 2009, June was the month with the lowest total sales.

Week 4 Quiz Answers

Quiz 1: Line Graphs

Q1. How can one change the formatting of a graph’s axis? Click all that apply.

  • Right click anywhere inside the chart
  • Right click on the axis
  • Use the layout tab
  • Left click on the axis

Q2. Examine the line chart below (click the file link to view a larger version of the image). What will happen to the chart when one changes the content of cell B1 to “United States.”

  • The current line for Brazil will move above the current line for China.
  • Chart title will change to “GDP of the United States.”
  • The current line for Brazil will be relabeled “United States” in the legend.

Quiz 2: Bar Graphs and Pie Charts

Q1. Approximately how much higher is the GDP of China compared to Brazil? Use billions of dollars, ex. 40,000,000,000 should be written as 40.

Left column- Brazil’s GDP at ~ $15 B; Center- China’s GDP at ~$60 B

Enter answer here

Q2. What can we not learn from the following pie chart?

  • Carol sold more than Brad and Adam combined.
  • Adam sold the least.
  • Adam, Brad, and Carol combined to represent 100% of sales.
  • Altogether, Adam, Brad, and Carol sold $100 worth of goods.

Quiz 3: Pivot Charts

Q1. Pivot charts are powerful because they allow
you to…

  • construct line charts.
  • make charts interactive.
  • construct charts with more data.
  • flip charts from horizontal to vertical orientation.

Q2. The two sets of columns depict average values of unit and dollar sales respectively
What’s the fastest way to change the pivot chart above to view totals of unit and dollar sales?

  • Change
    “value field settings” for each variable from “average” to
    “sum” of that variable.
  • Change the data to represent totals rather than average.
  • Select sales region to reflect one region at a time.

Quiz 4: Scatter Plots

Q1. Which of the following reflects the main strength of a scatter plot?

  • Scatter plots can be used to visualize any two variables.
  • Scatter plots easily show time trends.
  • Scatter plots help visualize relationships between two variables.
  • Scatter plots visualize relationships between many variables.

Q2. What is the relationship between employee experience and sales demonstrated in the chart below?

  • As experience declines, sales increase.
  • As sales increase, experience increases.
  • As experience increases, sales increase.
  • Experience and sales are unrelated.

Quiz 5: Histograms Part 1

Q1. The columns in chart decrease in height (salaries) from left to right
Based on the histogram above, what can you say about income?

  • Income is skewed to the right. The majority of individuals in this dataset have low salaries relative to others in this dataset.
  • Income is skewed to the left. The majority of individuals in this dataset have high salaries relative to others in this dataset.
  • Salaries are symmetrically distributed.
  • The average salary is $103000.

Quiz 6: Histograms Part 2

Q1. What do you need to do in Excel versions prior
to 2016 to create a histogram?

  • Create bins for your data.
  • Enable DataAnalysis ToolPak.
  • Make sure the minimum value is larger than the smallest bin value.
  • Uncheck the chart option.

Q2. The graph shows 14 columns in 0-160 range
The graph shows 7 columns in 0-160 range
What was done to transform the first histogram into the second one?

  • Data multiplied by 2.
  • Doubled the number of data points.
  • Bin widths doubled.
  • New data is used.

Quiz 7: Advanced Graphing and Charting

Q1. Download the spreadsheet “chicagocrimedata.xlsx” below. Use the data in the “Question 1 – get data” tab for the remainder of the assignment.

Fill in the tab, “Question 1 – get data” using the VLOOKUP formula. What is the value in cell C200?

Enter answer here

Q2. Use a pivot chart to create a bar plot of the average assaults by day of week. Which days of week has the fewest assaults on average?

  • Weekdays (Monday – Friday)
  • Weekends (Saturday and Sunday)
  • Sunday and Monday
  • Friday and Thursday

Q3. Modify the pivot plot to plot the average temperatures by day of week. What does it look like?

  • The frequency on the y-axis varies from 60-80
  • The frequency on the y-axis varies from 51.4-53.2
  • The frequency on the y-axis varies from 56-63
  • The frequency on the y-axis varies from 2900-3300

Q4. Create a scatter plot of Assault (Y axis) vs. Temperature (X axis). What does it look like?

  • The chart shows a scattered plot with a bell shaped trend
  • The scatter plot is upward sloping with closely aligned data points ranging from 28~110 along x-axis
  • The scatter plot is upward sloping with data points ranging from 700~1600 aling x-axis
  • The scatter plot is upward sloping with data points ranging from 10~100 along x-axis

Q5. What is the possible relationship between crime and temperature?

  • Crime increases as temperature rises.
  • Crime decreases when temperature rises.
  • Temperature and crime are unrelated.
  • Temperature increases as crime rises.

Q6. Find the minimum and maximum number of assaults, and create 10 evenly spaced bins that cover the data on assaults. What is the approximate bin width?

  • 8
  • 10
  • 15
  • 2

Q7. Create a histogram using the assaults data and 10 bins. What can you conclude based on the histogram?

  • The distribution of assaults is skewed to the right.
  • The distribution of assaults is symmetric.
  • 100 assaults is about a typical day in Chicago.
  • Crime is highest midweek?

Conclusion

Hopefully, this article will be useful for you to find all the Week, final assessment, and Peer Graded Assessment Answers of Introduction to Data Analysis Using Excel Quiz of Coursera and grab some premium knowledge with less effort. If this article really helped you in any way then make sure to share it with your friends on social media and let them also know about this amazing training. You can also check out our other course Answers. So, be with us guys we will share a lot more free courses and their exam/quiz solutions also, and follow our Techno-RJ Blog for more updates.

360 thoughts on “Introduction to Data Analysis Using Excel Coursera Quiz Answers 2022 | All Weeks Assessment Answers [💯Correct Answer]”

  3. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your blog? My blog is in the very same area of interest as yours and my visitors would certainly benefit from some of the information you present here. Please let me know if this okay with you. Thank you!

    Reply

  5. Hey very cool blog!! Guy .. Beautiful .. Superb .. I will bookmark your site and take the feeds also…I am happy to search out a lot of helpful info right here in the submit, we need work out more strategies in this regard, thank you for sharing. . . . . .

    Reply

  6. Thank you for the sensible critique. Me and my neighbor were just preparing to do some research about this. We got a grab a book from our area library but I think I learned more clear from this post. I am very glad to see such excellent info being shared freely out there.

    Reply

  9. Thanks for sharing excellent informations. Your web-site is so cool. I am impressed by the details that you have on this site. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found simply the information I already searched all over the place and simply could not come across. What a perfect web site.

    Reply

  10. Heya i am for the primary time here. I found this board and I to find It truly helpful & it helped me out much. I’m hoping to offer one thing again and aid others such as you aided me.

    Reply

  12. With every thing which appears to be developing throughout this specific subject material, all your viewpoints are generally rather stimulating. However, I beg your pardon, because I can not give credence to your entire idea, all be it refreshing none the less. It seems to everybody that your opinions are not entirely validated and in actuality you are your self not even thoroughly certain of the argument. In any case I did enjoy looking at it.

    Reply

  16. The next time I read a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to read, but I actually thought youd have something interesting to say. All I hear is a bunch of whining about something that you could fix if you werent too busy looking for attention.

    Reply

  19. Hi, I think your site might be having browser compatibility issues. When I look at your website in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, fantastic blog!

    Reply

  22. Hmm is anyone else having problems with the images on this blog loading? I’m trying to determine if its a problem on my end or if it’s the blog. Any responses would be greatly appreciated.

    Reply

  23. I am really impressed with your writing skills as well as with the layout on your weblog. Is this a paid theme or did you modify it yourself? Either way keep up the nice quality writing, it’s rare to see a nice blog like this one these days..

    Reply

  24. You actually make it seem so easy with your presentation but I to find this topic to be really something that I believe I would never understand. It sort of feels too complex and very extensive for me. I’m having a look forward to your subsequent publish, I will attempt to get the cling of it!

    Reply

  43. great post, very informative. I wonder why the other specialists of this sector do not notice this. You should continue your writing. I am sure, you’ve a huge readers’ base already!

    Reply

  85. Thank you so much for providing individuals with such a splendid possiblity to check tips from here. It is always very useful plus packed with fun for me and my office acquaintances to search your website more than thrice weekly to read the new tips you will have. And lastly, I am always satisfied with the amazing guidelines served by you. Selected 1 facts in this post are unquestionably the very best we’ve ever had.

    Reply

  91. To announce true to life news, dog these tips:

    Look for credible sources: https://projectev.co.uk/wp-content/pages/index.php?who-owns-hygo-news.html. It’s material to guard that the report roots you are reading is respected and unbiased. Some examples of reliable sources tabulate BBC, Reuters, and The Modish York Times. Announce multiple sources to pick up a well-rounded sentiment of a discriminating low-down event. This can better you return a more over paint and dodge bias. Be aware of the perspective the article is coming from, as even respected report sources can compel ought to bias. Fact-check the low-down with another fountain-head if a news article seems too lurid or unbelievable. Till the end of time pass persuaded you are reading a fashionable article, as scandal can transmute quickly.

    By means of following these tips, you can become a more au fait scandal reader and better apprehend the everybody everywhere you.

    Reply

  96. Totally! Find news portals in the UK can be overwhelming, but there are tons resources at to boost you think the best the same for you. As I mentioned before, conducting an online search for https://utopia-beauty.co.uk/wp-content/pgs/why-is-fox-news-app-not-working.html “UK scuttlebutt websites” or “British news portals” is a enormous starting point. Not one purposefulness this hand out you a comprehensive list of report websites, but it determination also provender you with a better savvy comprehension or of the coeval hearsay landscape in the UK.
    In the good old days you have a file of embryonic rumour portals, it’s powerful to evaluate each sole to influence which upper-class suits your preferences. As an exempli gratia, BBC News is known for its intention reporting of information stories, while The Custodian is known quest of its in-depth analysis of political and sexual issues. The Disinterested is known representing its investigative journalism, while The Times is known in search its affair and wealth coverage. Not later than entente these differences, you can pick out the rumour portal that caters to your interests and provides you with the rumour you want to read.
    Additionally, it’s usefulness all things close by despatch portals because fixed regions within the UK. These portals provide coverage of events and good copy stories that are applicable to the область, which can be especially cooperative if you’re looking to charge of up with events in your town community. In search exemplar, local dope portals in London include the Evening Standard and the Londonist, while Manchester Evening Talk and Liverpool Repercussion are stylish in the North West.
    Overall, there are tons statement portals accessible in the UK, and it’s high-ranking to do your experimentation to remark the one that suits your needs. At near evaluating the contrasting low-down portals based on their coverage, luxury, and essay viewpoint, you can decide the a person that provides you with the most relevant and captivating despatch stories. Esteemed luck with your search, and I anticipation this tidings helps you find the perfect dope portal for you!

    Reply

  107. I am currently writing a paper that is very related to your content. I read your article and I have some questions. I would like to ask you. Can you answer me? I’ll keep an eye out for your reply. 20bet

    Reply

  111. My coder is trying to convince me to move to .net from PHP.
    I have always disliked the idea because of the expenses.
    But he’s tryiong none the less. I’ve been using WordPress on numerous websites
    for about a year and am nervous about switching to another platform.

    I have heard great things about blogengine.net. Is there a way I can transfer all my wordpress content into it?

    Any help would be really appreciated!

    Reply

  143. I love your blog.. very nice colors & theme. Did you create this website yourself? Plz reply back as I’m looking to create my own blog and would like to know wheere u got this from. thanks

    Reply

  158. We wish to thank you just as before for the stunning ideas you gave Jeremy
    when preparing her own post-graduate research and also, most importantly, with regard to providing all of
    the ideas in a blog post. Provided that we had known of your
    web-site a year ago, i’d have been saved the pointless measures we were taking.
    Thank you very much. toys for adults

    Reply

  161. Definitely imagine that that you said. Your favourite reason seemed to be at the net the easiest factor to bear in mind of. I say to you, I definitely get irked while people consider concerns that they just do not recognise about. You controlled to hit the nail upon the top and defined out the whole thing without having side effect , people can take a signal. Will probably be again to get more. Thank you|

    Reply

  177. I think this is among the most important information for me.
    And i am glad reading your article. But should
    remark on few general things, The web site style
    is great, the articles is really nice : D. Good job,
    cheers

    Reply

  201. It is perfect time to make some plans for the long
    run and it’s time to be happy. I have read this submit and
    if I could I wish to suggest you some interesting issues or tips.
    Perhaps you can write next articles relating to this
    article. I want to learn even more issues about it!

    Reply

  228. I was suggested this website through my cousin. I’m not certain whether or not this submit is written through him as no one else know such distinct about my problem. You are wonderful! Thank you!

    Reply

  229. Good day! I know this is somewhat off topic but I was wondering which blog platform are you using for this website? I’m getting tired of WordPress because I’ve had problems with hackers and I’m looking at alternatives for another platform. I would be fantastic if you could point me in the direction of a good platform.

    Reply

  231. What i don’t understood is in truth how you are no longer actually a lot more neatly-liked than you may be now. You’re so intelligent. You recognize therefore considerably on the subject of this topic, produced me in my opinion consider it from a lot of varied angles. Its like women and men aren’t fascinated unless it’s one thing to do with Girl gaga! Your personal stuffs outstanding. All the time take care of it up!

    Reply

  235. I like what you guys are up also. Such intelligent work and reporting! Carry on the superb works guys I?¦ve incorporated you guys to my blogroll. I think it’ll improve the value of my site 🙂

    Reply

  239. Hi! Someone in my Facebook group shared this website with us so I came to check it out. I’m definitely enjoying the information. I’m bookmarking and will be tweeting this to my followers! Fantastic blog and amazing design.

    Reply

  240. I’m impressed, I have to say. Really rarely do I encounter a weblog that’s each educative and entertaining, and let me inform you, you may have hit the nail on the head. Your concept is outstanding; the problem is one thing that not enough persons are speaking intelligently about. I am very completely happy that I stumbled across this in my seek for one thing regarding this.

    Reply

  242. Good – I should definitely pronounce, impressed with your site. I had no trouble navigating through all tabs as well as related info ended up being truly simple to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your customer to communicate. Excellent task..

    Reply

  250. My brother suggested I might like this blog. He was entirely right.
    This post actually made my day. You cann’t imagine
    simply how much time I had spent for this info! Thanks!

    Reply

  254. Hey just wanted to give you a quick heads up. The text in your article seem to be running off the screen in Chrome. I’m not sure if this is a formatting issue or something to do with web browser compatibility but I thought I’d post to let you know. The layout look great though! Hope you get the issue fixed soon. Cheers

    Reply

  258. When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get four e-mails with the same comment. Is there any way you can remove me from that service? Thanks a lot!

    Reply

  260. Thank you for sharing excellent informations. Your site is very cool. I am impressed by the details that you’ve on this web site. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found simply the information I already searched everywhere and simply couldn’t come across. What an ideal site.

    Reply

  261. Nice read, I just passed this onto a colleague who was doing a little research on that. And he actually bought me lunch since I found it for him smile So let me rephrase that: Thanks for lunch! “Too much sanity may be madness. And maddest of all, to see life as it is and not as it should be” by Miguel de Cervantes.

    Reply

  263. Крупный учебный и научно-исследовательский центр Республики Беларусь. Высшее образование в сфере гуманитарных и естественных наук на 12 факультетах по 35 специальностям первой ступени образования и 22 специальностям второй, 69 специализациям.

    Reply

  272. Thanks for the good writeup. It if truth be told was once a enjoyment account it. Glance complex to far introduced agreeable from you! By the way, how could we be in contact?

    Reply

  282. You actually make it seem so easy with your presentation but I find this matter to be actually something which I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang of it!

    Reply

  284. Hey very cool blog!! Man .. Excellent .. Amazing .. I will bookmark your site and take the feeds additionallyKI’m happy to seek out numerous helpful info here within the publish, we want develop more techniques in this regard, thanks for sharing. . . . . .

    Reply

  287. I’ve read some good stuff here. Certainly value bookmarking for revisiting. I surprise how so much effort you put to create this type of fantastic informative web site.

    Reply

  288. I have learn a few good stuff here. Definitely worth bookmarking for revisiting. I surprise how a lot effort you place to make the sort of wonderful informative site.

    Reply

  290. Thanks , I have recently been searching for info approximately this subject for a while and yours is the best I have came upon till now. But, what in regards to the conclusion? Are you positive in regards to the supply?

    Reply

  296. Admiring the dedication you put into your site and in depth information you offer. It’s good to come across a blog every once in a while that isn’t the same unwanted rehashed material. Excellent read! I’ve saved your site and I’m adding your RSS feeds to my Google account.

    Reply

  297. What is Renew? Renew is a dietary supplement designed to support blood flow while also aiming to boost testosterone levels andprovide an explosive energy drive

    Reply

  301. Greetings! I know this is kinda off topic however , I’d figured I’d ask. Would you be interested in trading links or maybe guest writing a blog post or vice-versa? My website covers a lot of the same subjects as yours and I think we could greatly benefit from each other. If you might be interested feel free to send me an e-mail. I look forward to hearing from you! Awesome blog by the way!

    Reply

  308. Hello! I know this is kinda off topic nevertheless I’d figured I’d ask. Would you be interested in trading links or maybe guest writing a blog post or vice-versa? My blog covers a lot of the same topics as yours and I feel we could greatly benefit from each other. If you are interested feel free to shoot me an email. I look forward to hearing from you! Excellent blog by the way!

    Reply

  310. Thank you for the sensible critique. Me and my neighbor were just preparing to do some research on this. We got a grab a book from our local library but I think I learned more from this post. I’m very glad to see such great information being shared freely out there.

    Reply

  311. It’s a shame you don’t have a donate button! I’d most certainly donate to this brilliant blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to brand new updates and will talk about this site with my Facebook group. Chat soon!

    Reply

  315. I’m still learning from you, but I’m trying to reach my goals. I certainly liked reading all that is written on your blog.Keep the tips coming. I enjoyed it!

    Reply

  316. Please let me know if you’re looking for a article author for your blog. You have some really good articles and I feel I would be a good asset. If you ever want to take some of the load off, I’d really like to write some articles for your blog in exchange for a link back to mine. Please blast me an email if interested. Thank you!

    Reply

  318. Good day! This post could not be written any better! Reading through this post reminds me of my previous room mate! He always kept chatting about this. I will forward this page to him. Fairly certain he will have a good read. Thanks for sharing!

    Reply

  325. I think other web site proprietors should take this website as an model, very clean and magnificent user friendly style and design, as well as the content. You’re an expert in this topic!

    Reply

  328. Thank you for another informative web site. Where else could I get that kind of info written in such an ideal way? I have a project that I’m just now working on, and I’ve been on the look out for such information.

    Reply

  335. Thank you, I’ve just been looking for information about this topic for a while and yours is the greatest I have came upon so far. But, what in regards to the conclusion? Are you positive about the supply?

    Reply

  339. Hi! I know this is kind of off topic but I was wondering which blog platform are you using for this website? I’m getting sick and tired of WordPress because I’ve had issues with hackers and I’m looking at options for another platform. I would be great if you could point me in the direction of a good platform.

    Reply

  340. вакансии бухгалтер по заработной плате частичная занятость москва вакансии армянский театр в москве советской армии премиум ойл интернет
    магазин москва победа авиакомпания телефон
    поддержки москва бесплатный

    Reply

  342. What i do not understood is in fact how you’re not really much more smartly-appreciated than you may be now. You are so intelligent. You know thus considerably when it comes to this matter, made me in my view believe it from so many varied angles. Its like women and men are not involved unless it is one thing to do with Woman gaga! Your personal stuffs great. At all times care for it up!

    Reply

  343. Nice post. I learn something more challenging on different blogs everyday. It will always be stimulating to read content from other writers and practice a little something from their store. I’d prefer to use some with the content on my blog whether you don’t mind. Natually I’ll give you a link on your web blog. Thanks for sharing.

    Reply

  345. Excellent post. I was checking continuously this blog and I am impressed! Very useful information specially the last part 🙂 I care for such info a lot. I was seeking this particular info for a long time. Thank you and good luck.

    Reply

  346. Its like you read my mind! You appear to know a lot about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a little bit, but other than that, this is magnificent blog. An excellent read. I will certainly be back.

    Reply

  348. A large percentage of of the things you assert happens to be supprisingly accurate and it makes me ponder the reason why I had not looked at this in this light before. Your article truly did turn the light on for me personally as far as this particular subject matter goes. Nevertheless at this time there is 1 issue I am not necessarily too comfy with so whilst I attempt to reconcile that with the main idea of the position, permit me observe just what all the rest of the subscribers have to point out.Well done.

    Reply

  349. 1954 жылы көктемде қабылданған үкімет шешімі, қазақстан бойынша жыртылған жерлер мен үшін білімнің артықшылығы эссе, білім
    мен байлық эссе латынь грамматика для начинающих, склонение
    прилагательных латынь онлайн серікбол қондыбай өмірбаяны, серікбол қондыбай музейі

    Reply

  350. Pa MILFNAKNAFOTON hittar du de mest lockande milfarna pa natet. Dessa mogna kvinns alskar att uttrycka upp sina underbara kroppar och stora brost i kostnadsfritt gallerier som farsa dig att förlora andan. Har finns allt fran hardcore porr till sensuella nakna bilder – det ar bara att valja & vraka! Om ni ar sugen pa att se sexiga damer som alskar att bli knullade hart, ar detta platsen for dej.

    Reply

  352. купить кальян алматы олх, купить кальян алматы бу функциялар мен
    процедуралар python, python функция жақсы сөз жан азығы, 10 жақсы сөз
    өмірге қол жеткіз, өмір сүру қандай ғажап
    эссе

    Reply

  355. Can I just say what a reduction to find someone who truly knows what theyre speaking about on the internet. You undoubtedly know easy methods to deliver a difficulty to light and make it important. More folks need to learn this and understand this side of the story. I cant imagine youre no more popular since you positively have the gift.

    Reply

  357. монохромат жарықтың интерференция ланатын,
    де бройль толқыны формуласы музыка сабағында қолданылатын әдіс-тәсілдер,
    музыка сабағында қолданылатын ойындар африка мен оңтүстік американың ұқсастығы, оңтүстік америка мен солтүстік
    американың айырмашылығы 1771 жылы
    абылай хан үш жүздің ханы атанған қала, абылай хан өмір жолы

    Reply

  358. Immerse yourself in a massive array of photos featuring seductive grandmothers, properly chosen to satisfy your wishes. These mature models, usually within their 50s and older, are really mesmerizing. Witness older naked grannies engaging in anal intercourse, delivering mind-blowing blowjobs, and indulging in team sex with genuine enjoyment.

    Reply

  359. If you’re into something the bit rougher, SEXYGRANNYPICS.COM won’t allow you down. The site is packed along with galleries of grannies received it in every hole, covered within cum, and more. The particular Nude Pics of Art Of Older Women Part One section contains large amount of the hottest gran porn that can make you completely satisfied.

    Reply

  360. The photography on mILf fAnTASy PoRN PiCS is nothing short of breathtaking. Each scene captures every expression in vivid detail, thanks to perfect focus. These MILFs radiate natural beauty, bringing their unique personality to every frame. Whether it’s a bold pose, the connection feels personal and electrifying.

    Reply

Leave a Comment

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker🙏.