Final Exam
ENGR-125
Due Date:
Question 1: Excel Goal Seek
Use the Excel Goal Seek to find one root for the following equation where n is your student ID number:
Hint: is given, and you only have one equation and one unknown. Please select the initial value of to be zero.
Please submit your Excel file for this part.
Question 2: MATLAB For and IF Applications
Write a program in MATLAB/Octave to list all prime numbers up to the last three digits of your student ID number. Include both your code and your results. Please do not use the ‘isprime’ built-in function. Show your code for prime number detection. You should have this code in your project 6 and also in class activity for loops lecture.
Question 3. Fit polynomial functions on data using MATLAB
Step 1- upload Startups.xlsx file to Octave Online/ MATLAB
Step 2- Read the content of the file using xlsread
Step 3- Scatterplot of Profit (on the y-axis) vs R&D (on the x-axis)
Step 4- Use polyfit to find the coefficients of a polynomial of degree 5
Step 5- Use polyval and plot to draw the plot
Please copy your code and results (don’t forgot to copy your charts) to a document and submit it.
For help, follow this video from class activity 11: https://youtu.be/47RvfJLwqS0
Question 4. Data visualization and Analysis using Python
Please download the following CSV data file to your computer https://drive.google.com/file/d/11QLir6r0mYrpIGGa_i6uVP6n4srOR4n2/view?usp=sharing
Make a copy of the following notebook and save it to your Google Drive. https://colab.research.google.com/drive/1Mem1E52eL7iqvb10pguYQSYH1kUV8OVc?usp=sharing
Page 2
Be sure to rename your notebook.
Step 1: Import the pandas, numpy, and seaborn libraries.
Step 2: Get the data using Pandas
Step 3: Map the column “Type_of_Car” to the following numerical values:
Type
Numerical Value
Compact
1
Small
2
Sporty
3
Midsize
4
Large
5
Van
6
Step 4: Complete the code to split the data into a training dataset and a test dataset:
Use the code: “train_dataset = dataset.sample(frac=0.8)” to make the training dataset
Find the code for creating the test dataset from your Notebook for Project 8
Step 5: Use the pairplot function to create plots for all variables, then answer these questions:
What relationship, if any, do you see between Weight and MPG_city?
(Add a Text cell to your notebook and type the answer into it)
What relationship, if any, do you see between Horsepower and MPG_city?
(Add a Text cell to your notebook and type the answer into it)
Step 6: Create a summary statistics table for all variables
You do not need to build any models for this test.
Please submit a link for your Notebook to Moodle.
Be sure that when you click “Get Link:” that you allow “Anyone with the link” to view it.
Remember, you may need to revise the data entries and variable names in several places, including on the pairplot!
