Beginners Coumputer Science

/in /by

Beginners Coumputer Science

  1. (15 points) Summarize the large data set given in the excel sheet by creating pivot tables. The data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date, and Country. To get the total amount exported of each product, drag the following fields to the different areas.
  • Product field to the Rows area.
  • Amount field to the Values area.
  • Country field to the Filters area.
  1. Show your pivot table. Beginners Coumputer Science
  1. Sort and show the table
  • To get the total amount exported to each country, of each product, drag the following fields to the different areas.
  • Country field to the Rows area.
  • Product field to the Columns area.
  • Amount field to the Values area.
  • Category field to the Filters area.

    ORDER A PLAGIARISM -FREE PAPER NOW

    Don't use plagiarized sources. Get Your Custom Essay on
    Beginners Coumputer Science
    Just from $15/Page
    Order Essay

Show your two-dimensional pivot table.

To easily compare these numbers create and show the pivot chart from the above two-dimensional pivot table.

  1. (5 Points) Write a program that transforms the following formula into Python code. Identify the inputs and outputs. Compile and run the program. Show the program and results.

temp =

 

  1. (5 Points) Body Mass Index (BMI) is a measure of health on weight. The interpretation of BMI for people 16 years or older is as follows:

BMI < 18.5 “Underweight”

Else if BMI < 25 “Normal”

Else if BMI < 30 “Overweight”

Else  “Obese”.

Transform the above rules into a Python program. Make sure to read the BMI from the keyboard. Compile and run the program. Show your program and the output.