拟合不精确更准确拟合 修改代码 读取数据data = xlsreadImpression&&CPCxlsx Sheet1;impression = data 1;cpc = data 2; 归一化处理normalized_impression = impression - minimpression maximpression - minimpression;normalized_cpc = c

% 读取数据 data = xlsread('Impression&&CPC.xlsx', 'Sheet1'); impression = data(:, 1); cpc = data(:, 2);

% 归一化处理 normalized_impression = (impression - min(impression)) / (max(impression) - min(impression)); normalized_cpc = (cpc - min(cpc)) / (max(cpc) - min(cpc));

% 剔除上下四分位之外的数据 lower_quartile_impression = prctile(normalized_impression, 25); upper_quartile_impression = prctile(normalized_impression, 75); valid_indices = normalized_impression >= lower_quartile_impression & normalized_impression <= upper_quartile_impression; normalized_impression = normalized_impression(valid_indices); normalized_cpc = normalized_cpc(valid_indices);

% 拟合数据 f = fittype('a * log(b * x)'); fit_result = fit(normalized_cpc, normalized_impression, f);

% 绘制拟合曲线和散点图 figure; scatter(normalized_cpc, normalized_impression); hold on; plot(fit_result); xlabel('Normalized CPC'); ylabel('Normalized Impression'); legend('Data', 'Fitted Curve');

% 输出拟合后的表达式 coefficients = coeffvalues(fit_result); a = coefficients(1); b = coefficients(2); expression = sprintf('Impression = %.2f * log(%.2f * CPC)', a, b); disp(expression)