使用MATLAB对竞价与曝光次数关系进行拟合和预测

%20%E8%AF%BB%E5%8F%96Excel%E6%95%B0%E6%8D%AE%0Adata%20%3D%20xlsread(%27Impression%26%26CPC.xlsx%27%2C%20%27Sheet1%27%2C%20%27A2%3AB212%27)%3B%20%25%20%E5%81%87%E8%AE%A2%E6%95%B0%E6%8D%AE%E5%9C%A8Sheet1%E4%B8%AD%EF%BC%8C%E6%9B%99%E5%8F%91%E6%AC%A1%E6%95%B0%E5%9C%A8%E7%AC%AC%E4%B8%80%E5%88%97%EF%BC%8C%E7%AB%9E%E4%BB%B7%E5%9C%A8%E7%AC%AC%E4%BA8%89%E5%88%97%0A%0Aimpressions%20%3D%20data(:,%201)%3B%20%25%20%E6%9B%99%E5%8F%91%E6%AC%A1%E6%95%B0%E6%95%B0%E6%8D%AE%0Abid%20%3D%20data(:,%202)%3B%20%25%20%E7%AB%9E%E4%BB%B7%E6%95%B0%E6%8D%AE%0A%0A%25%20%E6%89%BE%E5%88%B0%E7%A9%BA%E4%BD%8D%E7%BD%AE%E7%9A%84%E7%B4%A2%E5%BC%95%0Amissing_idx%20%3D%20isnan(impressions)%20%7C%20isnan(bid)%3B%0A%0A%25%20%E5%B0%86%E7%A9%BA%E4%BD%8D%E7%BD%AE%E5%A1%AB8%E6%8F%92%E4%BA8%E6%8F%90%E4%B8%BA%E4%B8%AD%E4%BD%8D%E6%95%B0%0Aimpressions(missing_idx)%20%3D%20median(impressions(~missing_idx))%3B%0Abid(missing_idx)%20%3D%20median(bid(~missing_idx))%3B%0A%0A%25%20%E7%94%BB%E5%87%BA%E6%95%A3%E7%82%B9%E5%9B%BE%0Ascatter(bid%2C%20impressions)%3B%0Axlabel(%27%E7%AB%9E%E4%BB%B7%27)%3B%0Aylabel(%27%E6%9B%99%E5%8F%91%E6%AC%A1%E6%95%B0%27)%3B%0Atitle(%27%E7%AB%9E%E4%BB%B7%E4%B8%8E%E6%9B%99%E5%8F%91%E6%AC%A1%E6%95%B0%E5%85%B3%E7%B3%BB%E6%95%A3%E7%82%B9%E5%9B%BE%27)%3B%0A%0A%25%20%E5%AE%9A%E4%B9%89%E6%A8%A1%E5%9E%8B%E5%87%BD%E6%95%B0%0Amodel%20%3D%20%40(x%2C%20bid)%20x(1)%20*%20exp(x(2)%20*%20(x(3)%20*%20bid%20%2B%20x(4)))%20.%20sin(2pi*x(5)bid)%3B%0A%0A%25%20%E5%AE%9A%E4%B9%89%E8%AF%AF%E5%B7%AE%E5%87%BD%E6%95%B0%EF%BC%88%E6%9C%80%E5%B0%8F%E4%BA8%C9%E4%BA8%89%E6%B3%95%EF%BC%89%0AerrorFunc%20%3D%20%40(x)%20sum((model(x%2C%20bid)%20-%20impressions).^2)%3B%0A%0A%25%20%E5%88%9D%E5%A7%8B%E5%8F%82%E6%95%B0%E5%80%BC%0Ax0%20%3D%20[1%2C%200.1%2C%200.1%2C%200.1%2C%200.1]%3B%0A%0A%25%20%E4%BD%BF%E7%94%A8fminsearch%E5%87%BD%E6%95%B0%E8%BF%9B%E8%A1%8C%E5%8F%82%E6%95%B0%E4%BC%B0%E8%AE%A1%0Ax%20%3D%20fminsearch(errorFunc%2C%20x0)%3B%0A%0A%25%20%E5%87%BA%E5%8F%91%E4%BC%B0%E8%AE%A1%E7%9A%84%E5%8F%82%E6%95%B0%E5%80%BC%0Aa%20%3D%20x(1)%3B%0Ab%20%3D%20x(2)%3B%0Ac%20%3D%20x(3)%3B%0Ad%20%3D%20x(4)%3B%0AT%20%3D%20x(5)%3B%0A%0A%25%20%E6%8F%90%E5%87%BA%E5%8F%82%E6%95%B0%E5%80%BC%0Afprintf(%27%E4%BC%B0%E8%AE%A1%E7%9A%84%E5%8F%82%E6%95%B0%E5%80%BC%EF%BC%9A%5Cn%27)%3B%0Afprintf(%27a%20%3D%20%.2f%5Cn%27%2C%20a)%3B%0Afprintf(%27b%20%3D%20%.2f%5Cn%27%2C%20b)%3B%0Afprintf(%27c%20%3D%20%.2f%5Cn%27%2C%20c)%3B%0Afprintf(%27d%20%3D%20%.2f%5Cn%27%2C%20d)%3B%0Afprintf(%27T%20%3D%20%.2f%5Cn%27%2C%20T)%3B%0A%0A%25%20%E4%BB%A3%E5%85%A5%E5%8F%82%E6%95%B0%E7%BB%98%E5%88%B6%E6%9B%B2%E7%BA%BF%E5%9B%BE%EF%BC%88%E5%8C%85%E6%8B%AC%E6%8E%92%E9%99%A4%E5%A1%AB8%E6%8F%92%E6%95%B0%E6%8D%AE%E5%90%8E%E7%9A%84%E6%95%A3%E7%82%B9%E5%9B%BE%EF%BC%89%0Ax_vals%20%3D%20linspace(min(bid)%2C%20max(bid)%2C%20100)%3B%20%25%20%E7%94%9F%E6%88%90%E6%A8%AA%E5%8F%8D%E5%8D%88%E6%95%B0%E6%8D%AE%0Ay_vals%20%3D%20model(x%2C%20x_vals)%3B%20%25%20%E8BA%8F%E7%AE%97%E7%AD%96%E5%8F%8D%E5%8D%88%E6%95%B0%E6%8D%AE%0A%0Afigure%3B%20%25%20%E5%88%9B%E5%BB%BA%E6%96%B0%E7%9A%84%E5%9B%BE%E5%BD%A2%E7%AA%97%E5%8F%A3%0Ascatter(bid%2C%20impressions)%3B%20%25%20%E7%BB%98%E5%88%B6%E5%8E%9F%E5%A7%8B%E6%95%B0%E6%8D%AE%E7%9A%84%E6%95%A3%E7%82%B9%E5%9B%BE%0Ahold%20on%3B%0Ascatter(bid(~missing_idx)%2C%20impressions(~missing_idx)%2C%20%27filled%27%2C%20%27MarkerFaceColor%27%2C%20%27r%27)%3B%20%25%20%E7%BB%98%E5%88%B6%E6%8E%92%E9%99%A4%E5%A1%AB8%E6%8F%92%E6%95%B0%E6%8D%AE%E5%90%8E%E7%9A%84%E6%95%A3%E7%82%B9%E5%9B%BE%0Aplot(x_vals%2C%20y_vals%2C%20%27g--%27%2C%20%27LineWidth%27%2C%202)%3B%20%25%20%E7%BB%98%E5%88%B6%E6%9C%89%E5%88%B6%E6%9B%B2%E7%BA%BF%0A%0Axlabel(%27%E7%AB%9E%E4%BB%B7%27)%3B%0Aylabel(%27%E6%9B%99%E5%8F%91%E6%AC%A1%E6%95%B0%27)%3B%0Atitle(%27%E7%AB%9E%E4%BB%B7%E4%B8%8E%E6%9B%99%E5%8F%91%E6%AC%A1%E6%95%B0%E5%85%B3%E7%B3%BB%E6%95%A3%E7%82%B9%E5%9B%BE%E5%8F%8A%E6%9C%89%E5%88%B6%E6%9B%B2%E7%BA%BF%27)%3B%0Alegend(%27%E5%8E%9F%E5%A7%8B%E6%95%B0%E6%8D%AE%27%2C%20%27%E6%8E%92%E9%99%A4%E5%A1%AB8%E6%8F%92%E6%95%B0%E6%8D%AE%E5%90%8E%E7%9A%84%E6%95%B0%E6%8D%AE%27%2C%20%27%E6%9C%89%E5%88%B6%E6%9B%B2%E7%BA%BF%27)%3B%0A%0A%25%20%E968F%E6%9C%BA%E9%80%89%E5%8F%9680%25%E7%9A%84%E6%95%B0%E6%8D%AE%E4%BD%9C%E4%B8%BA%E8%AE%AD%E7%BB%83%E9%9B%86%EF%BC%8C20%25%E7%9A%84%E6%95%B0%E6%8D%AE%E4%BD%9C%E4%B8%BA%E6%B5%8B%E8%AF%95%E9%9B%86%0An%20%3D%20size(data%2C%201)%3B%0Atrain_idx%20%3D%20randperm(n%2C%20round(0.8n))%3B%20%25%20%E968F%E6%9C%BA%E9%80%89%E5%8F%9680%25%E7%9A%84%E7%B4%A2%E5%BC%95%E4%BD%9C%E4%B8%BA%E8%AE%AD%E7%BB%83%E9%9B%86%0Atest_idx%20%3D%20setdiff(1%3An%2C%20train_idx)%3B%20%25%20%E5%89%A9%E4%BD%8E%E7%9A%84%E7%B4%A2%E5%BC%95%E4%BD%9C%E4%B8%BA%E6%B5%8B%E8%AF%95%E9%9B%86%0A%0Atrain_data%20%3D%20data(train_idx%2C%20%3A)%3B%0Atest_data%20%3D%20data(test_idx%2C%20%3A)%3B%0A%0Atrain_impressions%20%3D%20train_data(:,%201)%3B%0Atrain_bid%20%3D%20train_data(:,%202)%3B%0A%0Atest_impressions%20%3D%20test_data(:,%201)%3B%0Atest_bid%20%3D%20test_data(:,%202)%3B%0A%0A%25%20%E91CD%E6%96%B0%E8%BF%9B%E8%A1%8C%E5%8F%82%E6%95%B0%E4%BC%B0%E8%AE%A1%0Atrain_missing_idx%20%3D%20isnan(train_impressions)%20%7C%20isnan(train_bid)%3B%0Atrain_impressions(train_missing_idx)%20%3D%20median(train_impressions(~train_missing_idx))%3B%0Atrain_bid(train_missing_idx)%20%3D%20median(train_bid(~train_missing_idx))%3B%0A%0Ax%20%3D%20fminsearch(@(x)%20sum((model(x%2C%20train_bid)%20-%20train_impressions).^2)%2C%20x0)%3B%0A%0A%25%20%E4%BD%BF%E7%94%A8%E8%AE%AD%E7%BB%83%E9%9B%86%E7%9A%84%E5%8F%82%E6%95%B0%E8%BF%9B%E8%A1%8C%E9%A2%84%E6%B5%8B%0Atrain_predictions%20%3D%20model(x%2C%20train_bid)%3B%0Atest_predictions%20%3D%20model(x%2C%20test_bid)%3B%0A%0A%25%20%E8BA%8F%E7%AE%97%E8%AE%AD%E7%BB%83%E9%9B%86%E5%92%8C%E6%B5%8B%E8%AF%95%E9%9B%86%E7%9A%84%E5%9D%87%E6%96%B9%E8%AF%AF%E5%B7%AE%0Atrain_mse%20%3D%20sum((train_predictions%20-%20train_impressions).^2)%20/%20length(train_impressions)%3B%0Atest_mse%20%3D%20sum((test_predictions%20-%20test_impressions).^2)%20/%20length(test_impressions)%3B%0A%0Afprintf(%27%E8%AE%AD%E7%BB%83%E9%9B%86%E5%9D%87%E6%96%B9%E8%AF%AF%E5%B7%AE%EF%BC%9A%.2f%5Cn%27%2C%20train_mse)%3B%0Afprintf(%27%E6%B5%8B%E8%AF%95%E9%9B%86%E5%9D%87%E6%96%B9%E8%AF%AF%E5%B7%AE%EF%BC%9A%.2f%5Cn%27%2C%20test_mse)%3B%0A