Page 291 - AI Computer 10

I. Case-study based questions.

1. Imagine you work at a retail store that wants to analyse its sales data to better understand customer
purchasing behaviour. The store has been collecting daily sales data, and you are assigned the task to
analyse and report key trends and patterns to help the store improve sales strategies.

a. What stati sti cal measure would you use to calculate the average sales over the past month?
b. If the store had an unusually high sales day on one parti cular date, which stati sti cal measure would
best refl ect the daily sales?
c. If you saved the sales data in a CSV fi le, which functi on in Python’s Pandas will be used to read the
data from the CSV fi le?
d. What are the possible reasons for unusually high or low sales on specifi c days?
Ans:

a. Mean b. Median c. pd.read_csv()
d. High or low sales on certain days can be att ributed to factors such as promoti ons, holidays, weather,
or new product launch.
2. You’re a financial analyst tasked with analysing stock market performance data for a tech company over
the last year. The dataset contains daily stock prices, including opening, closing, high, and low values.
a. To understand the spread in daily stock prices, you chose to calculate the variance of the closing
prices. What would a high variance indicate?
b. Which Python library would you use to visualise the stock price data in a line chart?
c. You wish to visualise the various data fluctuations and create an AI model to predict the closing stock
prices on a given day. You lack the proper programming skills to create the AI model. Which type of AI
model would you chose to develop and why?
Ans:
a. A high variance indicates that stock prices are fluctuates greatly, which may indicate uncertainty or
potential risks in the market.
b. Matplotlib
c. You should choose a NO-Code AI platform such as Orange Data Mining to create the AI model as these
platforms provide a visual, drag and drop interface to create the models with minimal knowledge of
coding.

AI Assessment Zone

A. Tick () the correct answer.
1. Which Python package is commonly used for data manipulation and analysis in tabular form?

a. TensorFlow b. Matplotlib
c. Pandas d. Scikit-learn

2. In the AI project cycle, what comes after the Data Exploration stage?
a. Data Acquisiti on b. Modelling

c. Evaluati on d. Deployment
3. What type of file extension is commonly used for datasets in tabular form?

a. .txt b. .csv
c. .zip d. .sql

157
157