Data & Analytics

Simulates an Excel spreadsheet using text-based tables, executing formulas and formatting cells without providing explanations.

Solves statistical problems including hypothesis testing and descriptive statistics by providing only the calculations and final answer, omitting explanatory text unless explicitly requested.

Analyzes a provided dataset by formulating research questions, defining populations, classifying variables, identifying data issues, and summarizing numerical and categorical variables according to a specific academic rubric.

Formulate a machine learning problem statement that utilizes a sequential scheme involving two distinct ML approaches, where the output of the first subtask serves as the input for the second.

Validates sales order data to ensure quantity and total value fields are positive, and calculates missing total values using a specific user-provided formula.

Execute a hierarchical clustering workflow using hclust, including distance metric selection, linkage method choice, dendrogram plotting, and visual validation against external variables.

Load flattened image data from a CSV file with specific schema (label + pixel columns), create train/validation/test data loaders, and train a retrained VGG classification network.

Analyzes a given sequence of coin flips to predict the next 10 flips based on observed patterns (ignoring probability), and calculates the percentage of Heads and Tails for both sequences.

Solves statistics problems involving normal distributions, including calculating areas under the curve, specific values from z-scores, and population counts within ranges, adhering to specific precision requirements.

Execute a specific machine learning workflow for network intrusion detection that involves preprocessing, K-Means based outlier removal, Emperor Penguin Optimizer feature selection, Bi-LSTM training, and comprehensive evaluation.

Generate NBA statistical comparisons for teams or players, ensuring each metric lists the top 3 performers.

Transforms a single-column matrix into a multi-column matrix by splitting data into 24-row chunks, appends rows for average and max index, and calculates the most frequent max index.

Generates MATLAB code to perform time series forecasting by testing multiple ARIMA models, selecting the best one based on AIC, and plotting the forecast.

Calculates population variance and standard deviation manually using NumPy by following a specific step-by-step workflow involving array conversion, deviation calculation, squaring, and summing.

Analyzes provided lottery number series to generate optimized combinations based on frequency, supporting specific formats like '5 numbers + 2 stars'.

Build a Python model to recommend the top 10 similar movies using item-based collaborative filtering for a dataset with a specific 3-column schema (movie_id, title with year, pipe-separated genres).

Generate a structured discussion analyzing the application, benefits, challenges, and leadership strategies for classification and clustering techniques within a selected industry.

Calculates mean, median, and mode for raw data and frequency distributions, including modality classification. Computes GPA using a specific 4.0 scale and applies user-defined rounding rules.

Calculates a power score (1-10) based on height, weight, and body type, and simulates physical struggles where success is determined by these scores without evasion or defense.

Implements a rolling window prediction pipeline using DNN and CNN models with CHAID variable selection, mean imputation for missing values, and hyperparameter tuning.

Rewrites input text to be clear and not too formal while strictly preserving the original meaning, facts, and numerical data.

Acts as an experienced financial advisor to create savings plans based on income and expenses. If the goal is unattainable, it assesses user interests via questions, recommends investment destinations, and provides detailed study plans for the chosen option.

Generates professional vendor profiles or shipping/refund policy sections for marketplace listings based on provided raw data, formatted with specific H2 headings.

Generates a Python model using item-based collaborative filtering to recommend the top 10 similar movies, specifically handling datasets with movie ID, title (with year), and pipe-separated genres.