Order from us for quality, customized work in due time of your choice.
For question 1, submit your excel file. For questions 2 and 3, please copy your code and results (don’t forget to copy your charts) to a document and submit it. For question 4, Please share the link of google colab (be sure that when you click “Get Link:” that you allow “Anyone with the link” to view it) or download the python file as .ipynb and upload.
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
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:
a.
Use
the code: “train_dataset = dataset.sample(frac=0.8)” to make
the training dataset
b.
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:
a)
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)
b)
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!
Order from us for quality, customized work in due time of your choice.